Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
On Error Resume Next | Excel Programming | |||
On Error {...} Resume Next | Excel Programming | |||
On Error Resume Next ? | Excel Programming | |||
On Error Resume Next | Excel Programming | |||
On Error Resume Next | Excel Programming |