Fill formula

kenpcli

Board Regular
Joined
Oct 24, 2017
Messages
129
I need a script to fill a column with the formula in cell d2 until there is nothing in column a.

Thnak you
 

jtakw

Well-known Member
Joined
Jun 29, 2014
Messages
5,146
Hi,

Select D2, point to Cell/Fill Handle (little right square at bottom right corner of cell), Double Left click.
 

Trebor76

Well-known Member
Joined
Jul 23, 2007
Messages
4,498
Hi kenpcli,

Is this what you're after:

Code:
Option Explicit
Sub Macro2()

    Range("D2").Copy Destination:=Range("D3:D" & Cells(Rows.Count, "A").End(xlUp).Row)

End Sub
Robert
 

Forum statistics

Threads
1,086,116
Messages
5,387,921
Members
402,088
Latest member
poppa57

Some videos you may like

This Week's Hot Topics

Top