Error proofing macros


Posted by mark lancaster on November 14, 2001 10:31 AM

Is there a way to make a macro that skips certain parts if there's an error? I have a selection criteria (see my post earlier today) that I've only been able to solve with a two pass process, and it's possible that the second selection (Go To Blanks) may not pickup anything (whereapon the macro halts with an error). Is there anyway for the macro to continue, skipping to the next section, even if it hits an error?

Thx,

M.



Posted by faster on November 14, 2001 10:57 AM

You might try:

On Error Resume Next