Calculate Sheet

[crs245]

I have a massive program designed in Excel where Calculations take several seconds. Default is to have Calculation set to Manual (hit F9). I also have many macros that must re-calculate multiple times when called. Is there a way to tell the macro to calculate only the sheet so run time is reduced?


Thanks!

[mikerickson]

The VB instruction "Calculate" will do that.

[mrkirkman]

Kind of on the same note, is there a way to calc only selected cells, or do I have to calc the whole sheet? I have some large sheets, and when I make changes, I would like to only calc a small amount of columns rather than the entire sheet. Thanks!

[Kuskush]

You may specify whatever range you want to be calculated

Worksheet(1).Range("D3:E10").Calculate
Cells(1,1).Calculate
Worksheets("Sheet1").UsedRange.Columns("A:B").Calculate

[crs245]

You may specify whatever range you want to be calculated

Worksheet(1).Range("D3:E10").Calculate
Cells(1,1).Calculate
Worksheets("Sheet1").UsedRange.Columns("A:B").Calculate

Thank you, the base instruction Calculate with no reference applies to the entire file. I'll try these out!

[bruce williams]

I have the same need---to cause the formula in one cell to calculate while leaving all other cells with formulas uncalculated. I see the code you have discussed in previous replies for calcualting only a limited range of cells, but I am not experienced with VBA, which I assume that code is. Is there a simple explanation of how to enter the required code into my excel file, or do I need to go get educated in VBA first? thanks, Bruce