Coming out of macro with error message
Posted by yogesh k. potdar on October 31, 2001 12:33 PM
I would like to the macro to stop and come out with a warnign message that - say "Cannot run on this file, check file contents" - if its unable to process the file - because of various reasons - e.g. data format not correct or divide by zero or something else..
Basically a generic way in which macro "stops" when it encounters error or cannot proceed rather than just
It would be great if someone can suggest how to know the error codes - i.e. macro stops with "OVerflow" or
"Bad Data type" or something like that..