straggleyway
New Member
- Joined
- Mar 1, 2009
- Messages
- 5
Hi all,
This is driving me crazy. Really grateful for help. I want to make a macro that I can copy a column of numbers, select a cell... then run the macro - which will transpose them and paste the values.
I've tried to make this by Recorder... but I keep getting an error.
Run-time error 1004
Paste-Special method of Range class failed.
I've seen other people in the past post this questions, but it seems noone has solved it!
Any ideas? Code below....
Thank you!!
Sub Transpose()
'
' Transpose Macro
' Macro recorded 11/03/2009
'
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
End Sub
This is driving me crazy. Really grateful for help. I want to make a macro that I can copy a column of numbers, select a cell... then run the macro - which will transpose them and paste the values.
I've tried to make this by Recorder... but I keep getting an error.
Run-time error 1004
Paste-Special method of Range class failed.
I've seen other people in the past post this questions, but it seems noone has solved it!
Any ideas? Code below....
Thank you!!
Sub Transpose()
'
' Transpose Macro
' Macro recorded 11/03/2009
'
'
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
End Sub