okay but how do you use this as a named range if its in 3D workbooks? It
just gives me an error that theres an error in the formula when I try
and enter the formula


--
King
------------------------------------------------------------------------
King's Profile: http://www.excelforum.com/member.php...o&userid=34815
View this thread: http://www.excelforum.com/showthread...hreadid=545705