Consuelo

Perhaps you have no Sheet1 ?

Gord Dibben Excel MVP XL2002

On Sat, 20 Sep 2003 19:21:44 -0700, "CBG" wrote:

Hello,
How can I add a date to a cell?
I have tried
Worksheets("Sheet1").Range("A1").Value = Now
But I keep getting a subscript out of range error message.
Please help!
Thanks. :-)
Consuelo