| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Fill Column with Date based on rows in other column
I have a spreadsheet that has 5 columns in it. The report varies in length
every day. I want Column E to prefill with todays date as many rows as in column A, the header for this column is "ConfDate". This code is not working, any help you can give me is appreciated. Thanks ActiveCell.FormulaR1C1 = "ConfDate" Columns("E:E").Select Range("E:E").Activate Selection.Style = "=TODAY()" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill text columns based on rows | Excel Worksheet Functions | |||
| Auto-Fill Column based on data in each row | Excel Worksheet Functions | |||
| Fill a column with the contents of another column based on a choic | Excel Discussion (Misc queries) | |||
| Auto fill Column based on data in other columns | New Users to Excel | |||
| Fill a column in a worksheet from a formula worksheet based on the date | Excel Programming | |||
Threaded Mode
