please adjust my code to fill the calendar into range H to S after
insert a new value into A1
In effect clear the range H2:S40 and auto fill the calendar
My code is into event change of shee

+-------------------------------------------------------------------
|Filename: step_date.zip
|Download: http://www.excelforum.com/attachment.php?postid=3949
+-------------------------------------------------------------------

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=47925