Range("A21:C21").FillDown

would fill A21:C21 with the values in A20:C20

as an example. another example:

set rng = Range("A1:A50").specialcells(xlblanks)
for each cell in rng
cell.Resize(1,3).filldown
next

might be what you want.



--
Regards,
Tom Ogilvy


"FurRelKT" wrote:

Correct Tom, here is a better Subject:

Need help with adding values to the Subtotal Row.
(values that are from the above row).

Does that explain my issue better?

Any place you can direct me to learn would be greatly appreciated.
I just want to learn the correct way.

Keri


Tom Ogilvy wrote:
subtotal adds the value for the column it is subtotalling on. For each
subtotal row, that can only be one column.

--
Regards,
Tom Ogilvy