What syntax do I use to add todays date in an excel macro

[Skeatt]

I'm using office 2003 and would like to add todays date to a specific cell
during the running of a macro.
What is the syntax to accomplish this?

(when I record a macro I can select the cell I want but I figure the date
component has to be typed into the macro manually, ie edit macro and add the
required syntax)

[gocush]

Sub AddDate()
ActiveCell = Date
End Sub

"Skeatt" wrote:

> I'm using office 2003 and would like to add todays date to a specific cell
> during the running of a macro.
> What is the syntax to accomplish this?
>
> (when I record a macro I can select the cell I want but I figure the date
> component has to be typed into the macro manually, ie edit macro and add the
> required syntax)
>

[Norman Jones]

Skeatt,

Try:

Range("A1").Value = Date


---
Regards,
Norman



"Skeatt" <[email protected]> wrote in message
news:[email protected]...
> I'm using office 2003 and would like to add todays date to a specific cell
> during the running of a macro.
> What is the syntax to accomplish this?
>
> (when I record a macro I can select the cell I want but I figure the date
> component has to be typed into the macro manually, ie edit macro and add
> the
> required syntax)
>

[Dave Peterson]

with activesheet.range("b99")
.value = date
.numberformat = "mm/dd/yyyy"
end with

There's also now and time:

.value = now 'includes both time & date
.value = time 'just the time
.value = date 'just the date



Skeatt wrote:
>
> I'm using office 2003 and would like to add todays date to a specific cell
> during the running of a macro.
> What is the syntax to accomplish this?
>
> (when I record a macro I can select the cell I want but I figure the date
> component has to be typed into the macro manually, ie edit macro and add the
> required syntax)

--

Dave Peterson