does the following code equate to 900?
and what line does it hang on/ how do you know? have you stepped through line by line during the hang?
and are you aware that, because VBA is not the best language in the world (not even close) and the VBE and engine is not powerful whatsoever, whenever you have a long routine that requires minutes to run, you WILL see it, what you call, *hang*. and it will freeze up and the screen will go white if you try to transact. but keep in mind that the code is still running and nothing is wrong. I've never run into an issue like that where the stack actually did overflow and thus everything broke. I seriously doubt it would happen for you either.
Bookmarks