View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default how do I program a cell to automatically fill in today;s date?

allan, if you want the date to change put this in a cell, =TODAY()

if you don't want the date to change use a line of code like this maybe in a
workbook open event
Sheets("Sheet1").Range("A1") = Date

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"allanlevy7342" wrote in message
...