Thanks for the reply Bob,

That is exactly the first thing that came to mind.... but I could never
get it to work so I assumed I was way off. This is what I have been
doing:

----
Sub import()
Dim var As String

var = Workbooks("master.xls").Worksheets("Sheet1").Range ("A2")
MsgBox var

End Sub

-------

Yet I always get an "Out of Range" error

Any ideas would be appreciated :)

Thanks again,

Matts


--
mattsvai
------------------------------------------------------------------------
mattsvai's Profile: http://www.excelforum.com/member.php...o&userid=31134
View this thread: http://www.excelforum.com/showthread...hreadid=507987