on error resume next dilemna
 

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

on error resume next dilemna
 

Hello Greg,

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

--
Regards,

OssieMac


"greg dixon" wrote:

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