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