Insert a date automatically in a Worksheet.
Posted on 2011-02-21
I am very new at this. This function works when I run it through VBA. I want to have the date inserting in the cell below when I open the workbook. I am assuming its the Openworkbook function. But I have no clue as to how to set this up. I know I use a Macro to call it. But I prefer to automate the function. An help is appreciated.
DateTime = Now
Range("F1").Value = Now