On Error End Sub

[Farah]

Hello,

I am getting an error "Run Time Error 424; object required" Continue, End, Debug etc. I know why am i getting this error.

I want that this error doesn't show. or maybe come back to excel sheet again witout any action.

I have tried the followings, but they don't seem to work.

On error GoTo 0
On error Resume Next (but this is not what i want)
Application.DisplayAlerts = False.


Warm Regards,
Farah

 

[Andrew Poulsom]

Try something like this:

On Error Goto Handler
' Your code
On Error GoTo 0
Exit Sub
Handler:
If Err = 424 Then
'  code to tidy up
   Exit Sub
Else
   Err.Clear
   Resume Next
End If

 

[Farah]

it works great !
Thank You Andrew

Warm Regards,
Farah