on error resume next dilemna

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
 
O

OssieMac

Hello Greg,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel On Error Resume Next 2
On error resume next 2
On error resume next 8
Adjusting height of text cells 3
Cannot Shift Objects Off Sheet 2
On Error {...} Resume Next 2
on error resume next 2
Loop doens't work properly (Error Handling) 0

Top