Calculate Formulas in Highlighted Cells Only--not whole sheet

T

Tony D

In office 97 I was able to recalc only the cells highlighted (control + L) as
opposed to the entire sheet or workbook. In Excel 2002, how do I recalc only
the cells I have highlighted? Thanks
 
D

Dave Peterson

I don't recall this shortcut in xl (any version).

I'm guessing that you had a macro that did something special.

In xl2002, you could use a macro like this (assigned to ctrl-shift-l)

Option Explicit
Sub testme()
Selection.Calculate
End Sub

But I think I've read posts that calculating a single range can be bad--it can
screw up the calculation dependencies.

I think that Charles Williams has posted some comments that recommend not doing
this.

Here's one thread.
http://groups.google.com/[email protected]

Charles has some more info at:
http://www.decisionModels.com/calcsecretsh.htm
 
Top