| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing clipboard through VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where does Ms XL store the clipboard ? or where does MS Windowsstore clipboard ? | Setting up and Configuration of Excel | |||
| Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
| ClearContents or ClearFormats also clears Clipboard. How can I keep the clipboard? | Excel Programming | |||
| Accessing Windows clipboard during runtime | Excel Programming | |||
| Accessing the clipboard after copyface | Excel Programming | |||
![pjelliffe[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
