Ignore Error 1004

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to ignore this error and NOT skip the code that makes the error!
 
before the code do

On Error Resume Next

after the code do

On Error goto 0
 
to you have break on all error set in the VBE. If so change it to break on
unhandled errors.
 
It may ignore the error, but it can't ignore what caused the error. You
need to fix your code so it puts in a valid formula.
 
It's not the above code that makes the error at the time I put the code in.
It's the reference: ("=PLC_STROEMFORS" & TaelTrafoOp) that has an error at
the time (exists though). The funny thing is that if I makes this validation
manual I just get an popup error that eksplains that the source at the moment
has an error but the change is accepted.

"Tom Ogilvy" skrev:
 
You must log in or register to reply here.

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

Number displayed as text difficulties 4
Interior.Color from a function yields Error 1004 3
Run-time error 1004 3
Runtime error 1004 write data to a cell 9
Troublesome tester- Is clicking top left select all...how to codetrap this? 2
"Run-time error '1004' 5
Runtime error 1004 when trying to insert formula in cells 11
Excel Run-time error '1004' General ODBC Error 1

Back
Top