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()"
Bookmarks