Hi

To isolate the problem, I think we need to comment out the application and
code lines one by one until the problem is not occur.
Or reversely, we can create a new Excel Workbook, and add the code
blocks/lines into the new excel workbook one by one to see what is the
cause.
So that we can minimize the code that will reproduce the problem.

Also the autocalc will calculate the formula on the sheet automatically.
You may also try to check if there will be some loop reference or
calculation in the sheet's formula.
To isolate the problem, we can create a new workbook and add the "suspect"
formula one by one to see what is the "culprit".

BTW: Have you tried my last suggestion that add the Debug.Print in the Loop
to see when the problem occurred, if the Debug.Print has any output.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.