Thread: Throw Exception if Clipboard is Empty
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
muddan madhu muddan madhu is offline
external usenet poster
  
Posts: 747
Default Throw Exception if Clipboard is Empty
Range("Q2").Select
Selection.PasteSpecial xlPasteValues

or

Range("q2").PasteSpecial xlPasteAll


On Oct 19, 6:46*pm, 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!

Reply With QuoteReply With Quote