You could attach this macro to a button on your toolbar, then copy your
range, select your destination, and click the button

Sub Macro1()
Selection.PasteSpecial Paste:=xlAll, _
Operation:=xlNone, SkipBlanks:=False, _
Transpose:=True
Application.CutCopyMode = False
End Sub

"pjelliffe" wrote:


Is there a way to access what's in the clipboard from a macro? FOr
example, I'd like to copy a range of cells, select a new location, and
paste the transpose of the original range. If I record this as a
macro, I have to hard code the range that gets copied.

I don't want to use Paste Special every time, it's too cumbersome.

I wasn't able to find any info on this in the help files.


--
pjelliffe
------------------------------------------------------------------------
pjelliffe's Profile: http://www.excelforum.com/member.php...o&userid=34315
View this thread: http://www.excelforum.com/showthread...hreadid=540802