Here is a really simple quick easy Macro for Error testing. Just insert an "Err_Msg" anywhere in the code. If an Err gets generated, the macro will tell you the Function/Sub name. Then you can start more intensive "If Err Then" trapping in that Function/Sub.
======================================
"The mistakes are all waiting to be made."
chessmaster Savielly Grigorievitch Tartakower (1887-1956)
on the game's opening position
======================================
Code:
' Macro Err_Msg If Err Then ? Using$("# ", Err) & Error$(Err), %MB_TASKMODAL, FuncName$ End If End Macro '
"The mistakes are all waiting to be made."
chessmaster Savielly Grigorievitch Tartakower (1887-1956)
on the game's opening position
======================================
Comment