Pasting in a unique row for each unique date
 

Under the "locals" screen at the bottom of VB, an error occurs at th
"res" step. It says "Error 2042" and "Variant/Error"

--
sowetoddi
-----------------------------------------------------------------------
sowetoddid's Profile: http://www.excelforum.com/member.php...nfo&userid=209
View this thread: http://www.excelforum.com/showthread.php?threadid=25157