Just use something like

Range("A1,C1,E1").Value = ""

Change the cells to the ones you want to clear.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"One-Leg" wrote in message
...
Hello,

I have a file that I would need certain cells to be cleared out
when the
file is opened for the first time during the day!!!

What the file does is basically for my employees asking to
leave earlier,
they add their name to the file, save it and close it. I want
to have a
macro that will run everytime the file is opened and if you are
the first
person opening it today (so basically if the last time it was
saved was for
yesterday's date), I would like to have certain fields to be
cleared...

If any one know of a way to do this, it would be great...

Thanks!!!