If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i insert todays date in a spread sheet just prior to print
wish to have excel automatically add date to same cell in spread sheet every
time it is opened. |
#2
|
|||
|
|||
how do i insert todays date in a spread sheet just prior to print
hi,
enter the formula =today() -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "wayne h" wrote: wish to have excel automatically add date to same cell in spread sheet every time it is opened. |
#3
|
|||
|
|||
how do i insert todays date in a spread sheet just prior to print
Your body description is at odds with your subject line.
Which is correct? Before Printing or when workbook is opened? You choose. Private Sub Workbook_BeforePrint(Cancel As Boolean) Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy") End Sub Private Sub Workbook_Open() Sheets("Sheet1").Range("A1").Value = Format(Date, "mm-dd-yyyy") End Sub Gord Dibben MS Excel MVP On Tue, 25 May 2010 10:39:01 -0700, wayne h wayne wrote: wish to have excel automatically add date to same cell in spread sheet every time it is opened. |
Thread Tools | |
Display Modes | |
|
|