Activesheet.Calculate failing to calculate

G

Guest

At some stage during my macro, I have the line "Activesheet.Calculate"

Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9
doesn't work either.

I've played around with Activesheet.EnableCalculation, without success.

F9 does recalculate the page, but I don't want to use this when I only want
one sheet calculated.

Thanks in advance

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ActiveSheet.Calculate not calculating 3
Accuracy of Using Calculate - IMPORTANT QUESTION PLEASE 2
Looping: Selecting elements from a named range to change calcs 4
Code to calculate only visible cells 1
command button to do F9 function 3
Trying to "clean up" some code... 1
Word Word 2007 form calculate field fails to udate when data entered 1
Word Word 2007 form fails to auto calculate total 5

Top