you can change it for all 7 sheets at a time.
Find what: April
Replace with: July
click "Options " tab. it will expand window
select
within: workbook
then press Replace all

does it work..?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539193