Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal row formula
Need the following formula to hit the 10th column over [column N at present, ie offset(0,10) ] for each subtotal row in d2.d500 - of which presently three rows come up, but there could be more or less rows depending on the content .... ActiveCell.Formula = ActiveCell.Formula & "/2" *** The tricky part [for me anyway!] is that it cannot apply to the Grand Total row, whose text also comes up in column d. This one's a bit out there, thanx for any ideas. Regards, - Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal and IF Formula | Excel Discussion (Misc queries) | |||
Using a Max Subtotal a Formula | Excel Worksheet Functions | |||
Subtotal formula | Excel Discussion (Misc queries) | |||
Help with SUBTOTAL formula | Excel Worksheet Functions | |||
Formula for the subtotal | Excel Programming |