Send me an email and I'll put together a sample file that does what you
want. Or, send me your file which would be even better. I'm at:

xl can help at comcast period net

Remove "can" and change the obvous.

Biff

"King" wrote in message
...

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