i would like to do the same thing. I have some fields that i would lik
to format with a for loop. I have
For iDate = 1 to NumOfDates
Sheets("requests").Cells(4, tDate * 2 + 1).Value = Format(StartDat
+ Format(tDate, "d"), "d-mmm")
Next

i know formatting an integer doesnt change its data type but i hope yo
can see my drift

--
norman1n
-----------------------------------------------------------------------
norman1nz's Profile: http://www.excelforum.com/member.php...fo&userid=2715
View this thread: http://www.excelforum.com/showthread.php?threadid=37207