Click on the first sheet's tab and then while holding down the Shift
key, click on the last sheet. All the tabs in your range should be
white.
Now you can create formulas, etc in all those sheets at once.
--
Vito
------------------------------------------------------------------------
Vito's Profile:
http://www.excelforum.com/member.php...o&userid=29182
View this thread:
http://www.excelforum.com/showthread...hreadid=495744