on error goto

**RBI** · 10-10-2008, 10:25 AM

hello,

I'm using a on error goto approach, heres the code.

On Error GoTo ErrorHand
  Windows("book1").Activate
ErrorHand:    MsgBox "Please download JDE Report, Save it as book1, And Run Macro Again", , "Warning!": Exit Sub

My problem is that the ErrorHand runs even when there is no error. I think its because of it's positioning in the code but i still can't fix it...

Anyone?

**BigBas** · 10-10-2008, 10:32 AM

I had this problem too. Errorhandler should in theory be the last line in your code, and should be preceded by Exit Sub.

ie,

Sub NewBook()
On Error GoTo ErrorHand
      Windows("book1").Activate
      'Enter All your Code here
    Exit Sub
ErrorHand:    MsgBox "Please download JDE Report, Save it as book1, And Run Macro Again", , "Warning!": Exit Sub
End Sub