Filldown Todays Date
 

Hello,

I'm looking for code to filldown Todays Date in a Range from A2 to end of
page.

Thanks,
Aaron

Filldown Todays Date
 

This is from VBA Help: Insert your sheet name and Range.
sub Filldown()
Worksheets("Sheet1").Range("A1:A10").FillDown
End Sub
--
Best wishes,

Jim


"Aaron" wrote:

Hello,

I'm looking for code to filldown Todays Date in a Range from A2 to end of
page.

Thanks,
Aaron

Filldown Todays Date
 

Aaron

Give this a try:

ActiveSheet.Range("A2:A60") = Now()

Adjust the range to suit your needs. You can format the cells in your
worksheet to display the date how you want or format the date in VBA using
Format(Now(),"mm/dd/yyyy").


"Aaron" wrote:

Hello,

I'm looking for code to filldown Todays Date in a Range from A2 to end of
page.

Thanks,
Aaron