Could you do a for each loop that has a sheet.visible inside?? Tha
would work.
--
ehnt
-----------------------------------------------------------------------
ehntd's Profile:
http://www.excelforum.com/member.php...fo&userid=1586
View this thread:
http://www.excelforum.com/showthread.php?threadid=27767