Hi all,

This is driving me crazy. Really grateful for help. I want to make a macro that I can copy a single 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 have posted this on other forums and it WORKS for other people - just not on my machine. Could it be my version of Excel or Windows?

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