| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deselecting a highlighted range after a VBA copy procedure | Excel Programming | |||
| Shading on highlighted range of cells | Excel Discussion (Misc queries) | |||
| autosum refusal to sum highlighted range | Excel Worksheet Functions | |||
| Loop Through Highlighted Range | Excel Programming | |||
| Range from highlighted area | Excel Programming | |||
Linear Mode
