Need Help calculating a highlighted range
 

would like to be able to highlight a range of cell then have the macro
calculate that area
--
Helping Is always a good thing

Need Help calculating a highlighted range
 

What would you like to calculate?

--
Cheers
Nigel



"QuietMan" wrote in message
...
would like to be able to highlight a range of cell then have the macro
calculate that area
--
Helping Is always a good thing

Need Help calculating a highlighted range
 

Selection.Calculate

--
Regards,
Tom Ogilvy


"QuietMan" wrote:

would like to be able to highlight a range of cell then have the macro
calculate that area
--
Helping Is always a good thing

Need Help calculating a highlighted range
 

Thanks Tom,

Here is what I came Up with, works like a charm

Sub RangeCalc()
Set RangeToCalc = ActiveWindow.RangeSelection
RangeToCalc.Calculate
End Sub
--
Helping Is always a good thing


"Tom Ogilvy" wrote:

Selection.Calculate

--
Regards,
Tom Ogilvy


"QuietMan" wrote:

would like to be able to highlight a range of cell then have the macro
calculate that area
--
Helping Is always a good thing