Sir Babydum GBE
01-30-2006, 01:54 AM
Good morning my friends...
I have a spreadsheet in which certain cells need to be automatically cleared once every day.
How do I say using VBA something like the following:
If on opening the sheet the date has changed from the last time it was modified, then do "x". If the date is the same, then do nothing.
I can do the clearing, I just don't know how to ask if a date has changed.
Thanks!
I have a spreadsheet in which certain cells need to be automatically cleared once every day.
How do I say using VBA something like the following:
If on opening the sheet the date has changed from the last time it was modified, then do "x". If the date is the same, then do nothing.
I can do the clearing, I just don't know how to ask if a date has changed.
Thanks!