Copy range down

Fernando G, · May 31, 2007

I have a macro that filter my data considering numbers in column "F" with

0, then place a formula in very cell from "O3:T3", and I need to copy this

range down to the last row with information.
I have used Macro record but it gives me the range taken and this can be
different every time.

Thanks

Bob Umlas · May 31, 2007

Range("O3:T" & Cells(Cells.Rows.Count,6).End(xlup).Row).FillDown
Bob Umlas
Excel MVP