View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
justaguyfromky justaguyfromky is offline
external usenet poster
 
Posts: 43
Default How to avoid an error dialog

Thanks, That did the trick.

Justa

"GS" wrote:

possibly:
At the beginning of the procedure add this:

On Error GoTo ErrorExit

Then insert this as the lines before "End" Sub or Function:

ErrorExit:
Err.Clear

-OR-
You could use On Error Resume Next at the beginning, to suppress any error
messages that may occur in the procedure.

I hope this helps!
GS