My macro occasionally runs into an unexpected condition and the mainframe (i guess) beeps and puts a little man up in the bottom line. I have to clear it with an escape but the macro keeps on going and I miss capturing data. Is there a way to trap the error and gracefully close the macro (or I could fix the error...)
Thanks,
Tom
Thanks,
Tom