View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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