| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code to halt a macro
Hi, I made a 'paste macro' which pastes data from clipboard to a designated area in the worksheet. However if a user runs the macro while there is no data in the clipboard macro error occurs. Need help with the code (if(iserror)) so I can display a text message, noting the missing data in the clipboard, and then terminate the macro. After which, the user will hopefully copy the necessary data to clipboard and rerun the 'paste macro'
Thank you in advance for all of your help.. Floss |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| halt a subroutine question | Excel Discussion (Misc queries) | |||
| Halt Rest of Macro after Error €“ Jim Cone review | Excel Discussion (Misc queries) | |||
| "No RETURN() or HALT() function found on macro sheet." | Excel Worksheet Functions | |||
| No RETURN() or HALT() function found on macro sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
