Thanks for the reply,
unfortunately I still get the nasty "Subscript out of range" error whe
I do that:
var = Workbooks("C:\User1.xls").Worksheets("Record").Ran ge("A2")
ARRGG
--
mattsva
-----------------------------------------------------------------------
mattsvai's Profile:
http://www.excelforum.com/member.php...fo&userid=3113
View this thread:
http://www.excelforum.com/showthread.php?threadid=50811