Forced recalculation in Excel

C

Claude

Hi all

I find that Excel does not always calculate properly when
pressing F9. I have been shown the trick with Ctrl-Alt-F9,
which forces a recalculation of all formulas in all open
files and sheets. Is there an equivalent to this in VBA?
 
C

Chip Pearson

Claude,

In Excel 2000 and later, use

Application.CalculateFull

In Excel 2002 and later, you can also use

Application.CalculateFullRebuild


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

forcing complete calculation 6
Recalculation of a spreadsheet 1
controlling excel recalculation in VBA? 5
Forcing to recalculate 7
UDFs in worksheets with external data sources 1
Excel 2007 Recalculation Bug 2
Ctrl+Alt+F9 not performing Full Recalculation on some PCs 4
Full recalculation when opening a workbook 6

Top