Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I'm looking for code to filldown Todays Date in a Range from A2 to end of page. Thanks, Aaron |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
Making a date go red, if date passes todays date. | Excel Worksheet Functions | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |