Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PasteSpecial error handling
I am currently in the middle of developing a macro which as part of the
routine will use something like Range("A1").PasteSpecial to paste whatever is currently on the clipboard. However, there is not necessarily anything waiting to be pasted and, if this was the case, the above statement would generate a runtime error. Can anyone suggest a way to 1) Detect whether or not there is data on the clipboard, and skip the routine if so or 2) If the macro tries to paste something that's not there, it handles the error and continues to function. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PasteSpecial Error 1004? | Excel Discussion (Misc queries) | |||
PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
Error handling with a handling routine | Excel Programming | |||
PasteSpecial error | Excel Programming | |||
PasteSpecial Error | Excel Programming |