Thanks Dave

I did it by name and attached a simple print command to the beginning
so that it always printed my first sheet and only printed the other
dependent on the value in a particular (same) cell in each of those
sheets.

Thanks for such clear help - I appreciate it.


--
davyb
------------------------------------------------------------------------
davyb's Profile: http://www.excelforum.com/member.php...o&userid=26401
View this thread: http://www.excelforum.com/showthread...hreadid=396776