Calculate Sheet

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!

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

Originally Posted by 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

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

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