M
MikeF
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
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