That'd be correct. Sorry. :(
Have you seen this post at Dick's?
http://www.dicks-blog.com/archives/2...sed-workbooks/
************
Anne Troy
www.OfficeArticles.com

"singlgl1" wrote in
message ...

Thanks Anne for the suggestion .Unfortunately, the workbook that I'll be
referencing will not always be open , therefore I'm not sure if the
indirect function would work for me.


--
singlgl1
------------------------------------------------------------------------
singlgl1's Profile:
http://www.excelforum.com/member.php...o&userid=26389
View this thread: http://www.excelforum.com/showthread...hreadid=479533