Debug.Print statement causes Excel crash
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. [....] The crash occurs only when a piece
of VBA is executed without the Visual Basic editor window opened.
I think there is more to this than meets the eye.
No problem for me with XL2003 using either of the following with the VBA
window closed.
Function myfunc()
Debug.Print , "test"
End Function
Sub mysub()
Debug.Print , "test"
End Sub
The function is invoked with the formula =myfunc(). The subroutine is
executed by pressing alt-F8, then clicking on Run.
|