Posted to microsoft.public.excel.programming

external usenet poster

Posts: 78

Error Trapping

For many of my procedures I trap errors with On Error GoTo Handler. Would it
be best to add Resume Next to the Handler?

Sub ()
On Error GoTo Handler
[code]
Exit Sub

Handler:
[whatever]
Resume Next
End Sub

Or is there a better approach? Thank you in advance.

Jim Kobzeff

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
Error Trapping from WSH	Tom Chau	Excel Discussion (Misc queries)	1	August 25th 06 04:21 AM
Error Trapping	Rafi	Excel Programming	3	February 14th 06 11:42 PM
Error trapping	Steve	Excel Programming	2	October 17th 05 10:52 PM
error trapping	[email protected]	Excel Programming	2	April 5th 05 12:52 AM
error trapping	libby	Excel Programming	5	November 25th 03 10:57 PM

All times are GMT +1. The time now is 02:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us