Latchmaker
Active Member
- Joined
- Sep 30, 2005
- Messages
- 308
This Macro fills Formulas to Last Row
I need it to also fill formats as well
Dim LastRow As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("W4:AA" & LastRow).Formula = Range("W3:AA3").Formula
I need it to also fill formats as well
Dim LastRow As Long
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
Range("W4:AA" & LastRow).Formula = Range("W3:AA3").Formula
