Instead of the range object use cells.
so for instance:
datevariable = sheets("Sheet2").cells(rowvariable,1)
valuevariable = sheets("Sheet2").cells(rowvariable,2)
--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread:
http://www.excelforum.com/showthread...hreadid=563633