Debug.Print statement causes Excel crash
On Saturday, June 15, 2013 1:06:07 PM UTC+2, wrote:
After some search effort I found the cause for an Excel crash. Just in case you experience the same this is what I discovered: In Excel 2003, 2007 (and later?) the statement Debug.Print , "test" causes Excel to crash. There is an <empty expression in front of the comma. The crash occurs only when a piece of VBA is executed without the Visual Basic editor window opened.
I'm happy that you were able to replicate the error. I posted this message because it might benefit others. Of course I found a way to avoid the error and retain the formatting for example in Debug.Print " ", <remainder
Thanks!
|