Prev: Multiple sheet references in one function
Next: returning a text value
From: wayne h wayne on 25 May 2010 13:39
wish to have excel automatically add date to same cell in spread sheet every
time it is opened.
From: Mike H on 25 May 2010 13:49
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.
From: Gord Dibben on 25 May 2010 14:15
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
h(a)discussions.microsoft.com> wrote:

>wish to have excel automatically add date to same cell in spread sheet every
>time it is opened.

 | 
Pages: 1
Prev: Multiple sheet references in one function
Next: returning a text value