how do I program a cell to automatically fill in today;s date?

P

Paul B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I subtract todays date from range of dates 2
Automatically populating cells down a row 8
Conditional Validation In Excel 1
="Printed " & today() 3
How do I set up a spreadsheet where it will automatically update? 0
How do I filter by today's date(changing) and before in a macro? 0
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Difference between NOW() and TODAY() 2

Top