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.
Bookmarks