Quite interesting. Thank you. The checks to test if Excel is already running I find particularly helpful.
As far as the On Error issues, it appears the solution is not to eliminate the statements but to limit use to "resume next" and disable through "GoTo 0" before exiting the sub.
Thank you for your valuable responses
|