VBA Add FillFormat to MAcro

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
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
How about
Code:
Range("W3:AA" & LastRow).FillDown
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top