Didn't see anything pertinent to the questions asked. Sure you posted this
in the correct thread. Unless you meant run it on each sheet manually which
the OP said he/she didn't want to do.

--
Regards,
Tom Ogilvy


"davesexcel" wrote
in message ...

http://tinyurl.com/r6mfz

and

http://tinyurl.com/mpq2d

These are the answers for you


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=524090