on error resume next dilemna

  • Thread starter Thread starter greg dixon
  • Start date Start date
G

greg dixon

I have been experiencing a problem recently that is sporadic but increasing.
Using VBA I have a line of code On Error Resume Next. I have been using
this command for years and never experienced this. The line is not
recognized when the program runs. If I go to the row above and hit enter to
shift the command down a line it works - sometimes.

Also, other programs will just run away and ingnore the lines of code. If I
shift the rows down a line to 2 it works. Sometimes I have to exit excel
and start again. I think this started after the last service pack update.

Help
 
Hello Greg,

Could you post the code that incorporates the On error. Bit difficult to
assess what might be occurring without it.
 
Back
Top