I have a macro that a user will run every day to gather information fro
another spreadsheet.

Right now the user has to delete the previous days info and run th
macro.
Is there a way I can have the macro test to see if the day of the wee
has changed, then to delete cells D3,D4,D5 & D6 and run the macro?

Also, i'd like to use the =now() function in the macro for cell A7 tha
when the macro runs, it tell the operator (sometimes a different person
when the program ran last?

thank

--
Message posted from http://www.ExcelForum.com