Can I calculate a single page ONLY?

D

dh13134

Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case)
to re-calculate where I'm running a macro that plugs a value into a cell and
gets an answer, plugs another value in and gets an answer, etc. I'd like to
calculate only the sheet where where the calculations are actually being
affected-I'm not concerned with the other sheets.

Thanks
DH
 
T

Tom Hutchins

Excel 2003 & 2007 (at least!) have the option to calculate only the current
sheet. Calculation must be set to Manual first. In XL2007 select Formulas
ribbon >> Calculation section >> Calculate sheet. In XL2003 select Tools >>
Options >> Calculation tab >> Calc Sheet. In either version the VBA command
is:

ActiveSheet.Calculate

Hope this helps,

Hutch
 

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

Calculate the median value before a specified list 0
VBA - exporting serial letters to single documents 0
Two columns followed by single page-width column on same page 0
Count After Filter in macro 2
Converting excel to PDF, single page converts to multiple HELP! 1
Can I add a formula or function to Vlookup? 1
Macro code to hide rows and not calculate hidden rows 0
Calculate message 1

Top