Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Dave;
That put me on the right track - missed a mental connection to "Precedents". (was extracting from a "FormulaArray" but KNEW there had to be an easier way-if not 30 different ways.) Turns out that; Cells(StRow, StCol).Precedents.Select For Each cl In Selection ' Do the tax exclusion using "Cells(cl.Row, cl.Column)" Next Is what I wanted Again, thanks. -- Regards; Rob ------------------------------------------------------------------------ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To find subtotal - Please help | Excel Discussion (Misc queries) | |||
subtotal by a range | New Users to Excel | |||
Subtotal of Abs of a range? | Excel Worksheet Functions | |||
Find, Loop, Subtotal | Excel Programming | |||
Find, Loop, Subtotal | Excel Programming |