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

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
I want to ignore this error and NOT skip the code that makes the error!

Doesn't work!

"Tom Ogilvy" skrev:

before the code do

On Error Resume Next

after the code do

On Error goto 0

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
I want to ignore this error and NOT skip the code that makes the error!

to you have break on all error set in the VBE. If so change it to break on
unhandled errors.

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
Doesn't work!

"Tom Ogilvy" skrev:

before the code do

On Error Resume Next

after the code do

On Error goto 0

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
I want to ignore this error and NOT skip the code that makes the
error!

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.

--
Regards,
Tom Ogilvy


"akyhne" wrote in message
...
It allready is!

the code is:
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:=("=PLC_STROEMFORS" & TaelTrafoOp)
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

... and it stops at
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:=("=PLC_STROEMFORS" & TaelTrafoOp)

but it has to ignore this error and "make" this code anyway!!!

"Tom Ogilvy" skrev:

to you have break on all error set in the VBE. If so change it to break
on
unhandled errors.

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
Doesn't work!

"Tom Ogilvy" skrev:

before the code do

On Error Resume Next

after the code do

On Error goto 0

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
I want to ignore this error and NOT skip the code that makes the
error!

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:

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.

--
Regards,
Tom Ogilvy


"akyhne" wrote in message
...
It allready is!

the code is:
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:=("=PLC_STROEMFORS" & TaelTrafoOp)
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With

... and it stops at
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:=("=PLC_STROEMFORS" & TaelTrafoOp)

but it has to ignore this error and "make" this code anyway!!!

"Tom Ogilvy" skrev:

to you have break on all error set in the VBE. If so change it to break
on
unhandled errors.

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
Doesn't work!

"Tom Ogilvy" skrev:

before the code do

On Error Resume Next

after the code do

On Error goto 0

--
Regards,
Tom Ogilvy

"akyhne" wrote in message
...
I want to ignore this error and NOT skip the code that makes the
error!