| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Throw Exception if Clipboard is Empty
On Oct 19, 7:46*am, PumaMan wrote:
I have a simple paste action in VBA: * * Range("Q2").Select * * ActiveSheet.Paste I'd like to catch and throw an exception if the user's clipboard is empty.. * Currently, the user gets the "End - Debug" general exception. I appreciate any help! How about something like... If Application.ClipboardFormats(1) = -1 Then MsgBox "Clipboard Empty!" End If ....Ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clipboard empty but still get waring that clipboard is full | Excel Discussion (Misc queries) | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| Cannot empty the Clipboard | Excel Discussion (Misc queries) | |||
| Cannot empty the clipboard | Excel Discussion (Misc queries) | |||
| Why is my clipboard empty? | Excel Programming | |||
Threaded Mode
