Macro to run if cell empty
"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
|