Hello,
I have an excel spreadsheet that has sub-totals which are SUM;s on various
bolded rows. Now, at the bottom of the spredsheet I'd like insert a formula
which would, for a particular column, add the values of the bolded rows

I can find the bolded row using by using:
If Selection.Font.Bold = True Then......

and I can insert a statement for one row by using something like:
cells(intRowVar, intColVar).Value = "=(R[" & -1 & "]C)"

but I can't seem to find a way to concatinate all the cell references
together and place them in the last row. Since they use relative
referencing, it varies by the time I place it in the final cell.

Thanks for your help.
--
Programmer on Budget