Day is a reseved name in excel and can't be used for a variable.
From
Sub Day_Dump(day As String)
To
Sub Day_Dump(Myday As String)
Then change all occurances of day in the subroutine.
--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=167136
Microsoft Office Help