Problem Sub Procedure 2007

[ultimastryder]

Hey all,

I have a sub routine thats crashing 2007 every single time like clockwork, but never crashed 2003.

Is there anything in this that would tank 2007????

Please Login or Register  to view this content.

[ultimastryder]

Ok this portion seems to have been the problem:

Please Login or Register  to view this content.

For now this is solved. However, should anyone have any input as to why this was the culprit code. Please share.

[shg]

Have you tried stepping through the code? Learning to debug is the best way to improve your programming.

http://www.cpearson.com/excel/Debug.htm