Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date but not TODAY() ...
Hi all,
I need a little macro for a worksheet template that enters the date into a cell the first time the worksheet is created/opened from the template but then preserves the original date thereafter ... in other words I cannot use the TODAY() function as it changes the date as the date progresses. Thanks in advance ... Michelle |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date but not TODAY() ...
Michelle,
Checking to see if the first cell has a date value, if not then set it to today Private Sub Workbook_Open() If Not IsDate(Sheet1.Cells(1).Value) Then Sheet1.Cells(1).Value = Date End Sub Rob "Michelle" wrote in message ... Hi all, I need a little macro for a worksheet template that enters the date into a cell the first time the worksheet is created/opened from the template but then preserves the original date thereafter ... in other words I cannot use the TODAY() function as it changes the date as the date progresses. Thanks in advance ... Michelle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date in excel from today to original date of file | Excel Discussion (Misc queries) | |||
Date Formula for number of days between a date and today | Excel Discussion (Misc queries) | |||
IF TODAY equals date in cell A10, or if TODAY is beyond that date | Excel Worksheet Functions | |||
MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions |