Excel Macro to insert date automatically (WNT)

[Senapathy]

Hello,
I have a set of records in Excel 2000. The first column of it is 'Date'. I want a macro like this. When I run this macro, it should automatically go to the first blank cell in the first column and insert the current date there. This is to avoid the user type in the date when he wants to create a new row.

Thanks,
Senapathy

[report_2]

I am unable to make a Macro work for this request but you may want to try selecting the first column and then go to Data, Validation,
Allow:"Date"
Data:"Equal To"
Date:"=today()"
(without the quotation marks)
and click Ok

If anything but todays date is entered then it will provide the warning that the data is not correct and a chance to try again.

HTH

<P ID="edit"><FONT class="small">Edited by report_2 on 05/07/02 14:29.</FONT></P>