Hi,

I'm trying to create a macro which will:
-Open on the sheet1
-Get today's date
-Compare today's date to a certain cell in the sheet
-If today's date is bigger (=the date on the cell has passed) - it'll
move to the next sheet and so on to the next sheets.

I thought you might have some suggestions, anyone?

Thanks,

Sivan.


--
Sivangen
------------------------------------------------------------------------
Sivangen's Profile: http://www.excelforum.com/member.php...o&userid=34925
View this thread: http://www.excelforum.com/showthread...hreadid=546614