Workbooks("Book 1998.xls").Worksheets("Sheet1").Range("F1")

the range has many properties such as .Value, .Formula, etc. which can tag
ob the end.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mattsvai" wrote in
message ...

Hi everyone! This is my first post on this board :)

I just want to know how I can do the following in VBA:

=[Book1998.xls]Sheet1!$F$1


Thanks!

Matts


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