Enclose the main body of Rowan's code with a For...Next Loop:
For each sh in Worksheets
Sh.Activate
Code
Next
David
--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread:
http://www.excelforum.com/showthread...hreadid=483394