Using For Next Loop with Formulas

[phelbin]

I'm trying to place subtotals 2 rows below the bottom row of several columns.

I can't use the range function because the last row is variable. So I was trying the use the code below, but it just places the exact same formula in each columns instead of adjusting it by column the way the range function would. How should I be doing this?

Please Login or Register  to view this content.

Thanks!!

[GC Excel]

Hello,

Here's a suggestion, using relative reference:

for example, if you are in G20,
R5C means, from Row5 in same column (G)
R[-2]C means : 2 rows before (18) in same column (G)

R5C:R[-2]C = G5:G18

Please Login or Register  to view this content.