When I went to school, If we used On Error Resume Next anywhere in our code,
we had points taken off our GPA. Some people may have a different oppinion,
but in my oppinion... It is a poor programing practice. And any place that
I've worked so far that does VB/VBA looks down upon it as well. In fact...
You are the first person I've run accross who seems to think other wise.

Best Regards,

Bob Calvanese

"Bob Phillips" wrote in message
...

"rcalvanese" wrote in message
...

"On Error Resume Next" is not a good programming practice.

That is far too general a statement.

You want to "handle erreors" not "ignore them".

In many cases, On Error Resume Next is helping to handle errors. For
example

On Error Resume Next
Set sh = Worksheets("somename")
On Error Goto 0
If sh Is Nothing Then
Worksheets.Add.Name = "somename"
End If