Run time error 1004 - I need one

[bnc_no_ice]

Hi all,

Can I artificially create a runtime error 1004 to check how my error handler reacts and what display happens? Can I also designate what type of error is generated, ie: if I want the same macro to produce error 75, etc.

Any suggestions on how to achieve this.

TIA

 

[Norie]

You could try Err.Raise, but I don't wuite see how that's going to help with your error-handling or the code.

 

[bnc_no_ice]

Norie, I see your point.
Maybe my wording was abit vague.
I want to use/write a macro that when activated will intentionally cause a runtime error (ieut code or details in the wb that I know is incorrect to cause a problem) to allow me to adjust my error handler as needed, meaning if "runtime error 1004 File locked etc etc" occurs do this. I am trying these on a new wb as I don't want to kill my actual code...yet.

 

[Norie]

Well I still don't quite understand what you mean.

If you want to check your error handling then use values or do things, eg leave a file open, that you know will cause errors.

Mind you I still don't see how that will help with your code.

Perhaps you should be looking into eliminating the errors in the first place.

Perhaps if you posted some code it'll make things clearer.