Calculating a highlighted range

[Schizoid Man]

Are there any utilities that enable me to calculate a highlighted range
of cells on my spreadsheet?

My sheet is pretty complicated, and I don't need to recalculate the
entire workbook each time for certain tasks.

Thanks,
Schiz

 

[Bob Phillips]

You could have a very simple macro tied to a button

Public Sub CalculateRange()

Selection.Calculate
End Sub


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Schizoid Man]

You could have a very simple macro tied to a button

Public Sub CalculateRange()

Selection.Calculate
End Sub

Wow - it's that simple? I never realized.

 

[Bob Phillips]

You would obviously have to have calculation mode set to Manual, else there
is little point.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)