cros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macros for paste special-transpose
copy the data area and use paste special -transpose it u wil get the
required r/shiva
On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote:
Hello All,
Please can somebody advise me macros for paste spe
copy the data area and use paste special -transpose it u wil get the
required
r/shiva
On Tue, Jan 25, 2011 at 8:42 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special-transpose wherein i
> can just copy the data in horizontal format and paste them in vertica
Sub Bang()
Dim Rng As Range
Set Rng = Cells(1).CurrentRegion
Rng.Copy
Rng(1).Offset(Rng.Rows.Count + 2, 0).PasteSpecial _
Paste:=xlPasteAll, Transpose:=True
End Sub
On Tue, Jan 25, 2011 at 10:12 AM, Manoj b wrote:
> Hello All,
>
> Please can somebody advise me macros for paste special
try this...
Sub Transpose()
'
' Macro Transpose
'
'
Range("A1").Select
Selection.CurrentRegion.Select
Selection.Copy
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Selection.End(xlDown).Select
Range("G1").Select
Selection.PasteSpecial Paste:=xlPasteValu
