Code to halt a macro

[Guest]

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

 

[Tom Ogilvy]

if application.CutcopyMode = False then
msgbox "No range copied. Exiting . . . "
Exit Sub
End if

--
Regards,
Tom Ogilvy

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