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