Add formulae to a subtotal line

I have VBA code that sorts and subtotals some data on my worksheet, and now I want to add formulas to some of the columns that do not have the subtotal function in them. This would be an offset formula to show the cell above, so when it is collapsed you can see the last entry that it is subtotaling without expanding.

Here is my subtotal code:

Please Login or Register  to view this content.

So it sums column B and C on the sheet, and I would like to add my own formula to some of the other columns. Any ideas?


Thanks in advance!

Hoffey

After thinking about it, I suppose I could make a loop that looks at column C and if the formula is equal to SUBTOTAL then paste the appropriate formulas on the adjacent cells. I will work on that for now and see if there are better solutions...