View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default How can I still go to the error-code after a On Error Goto?

Hi Michel;

You can use OnError Resume Next and then after the
potiential error use this:

If Err.Count < 0 Then
GoTo ErrorHandler
End If


-----Original Message-----
If I use the 'On Error Goto' to send a report by email

how can I
include the line code that caused the error?

And how can I still go to the vba-code-line to debug it?

It seems Err. is missing something like Err.Line or

Err.Code.....
.