I want to be able to use autosum across, in a macro. the amount of rows will always be different.
I was able to use the following macro, to dynamically autosum a column:
For Each NumRange In Columns("I").SpecialCells(
SumAddr = NumRange.Address(False, False)
ount, 0).Resize(1, 6).Formula = "=SUM(" & SumAddr & ")"
c = NumRange.Count
I would like to do the same in rows.
I've attached a PDF of the report I'm working with.