Hello. In the code below. I have the settings on manual and then I calculate and paste special values. The problem is that sometimes the calculate works and sometimes it doesn't (there are just values of 0 copy and pasted). Why might this be?
Please Login or Register to view this content.
Hi,
When your code hits this line:
Application.Calculation = xlCalculationManual
Excel will stop calculations until you turn it back on again or tell it to specifically calculate.
I see that you have two lines of:
ActiveSheet.Calculate.
This should make the active sheets recalculate, but what sheet is active? ALSO the sheets might be calculating but you have also turned off your ScreenUpdating so you might not be seeing the current calculations.
I hope one of the above hints gives you an answer.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
I noticed that if I don't move the mouse at all when it's running it tends to work correctly? Is tehre a way that I could modify the calculate piece. Maybe after all of the loops, instead of during each loop?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks