Posted to microsoft.public.excel.misc

gazza67[_2_] gazza67[_2_] is offline

external usenet poster

Posts: 8

Error Trapping

Can someone tell me why the following falls over with a runtime error
when the clipboard is empty (ie I do not get the msgbox)

On Error Resume Next
ActiveSheet.Paste
If Err Then MsgBox "Nothing to paste!": Err.Clear

Thanks,
Gary

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trapping #VALUE! error	RhysPieces	Excel Discussion (Misc queries)	6	August 22nd 07 03:13 AM
trapping charts event	PLP	Charts and Charting in Excel	2	June 21st 07 01:18 AM
Error Trapping from WSH	Tom Chau	Excel Discussion (Misc queries)	1	August 25th 06 04:21 AM
error trapping	flow23	Excel Discussion (Misc queries)	3	April 13th 06 04:51 PM
trapping for printer problems	TAndrew	Charts and Charting in Excel	0	December 22nd 05 09:11 PM

All times are GMT +1. The time now is 11:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us