use a for each looping macro
for each ws in worksheets
do something
next ws

--
Don Guillett
SalesAid Software

"Jeff" wrote in message
...
Hi,

I have a worksheet with about 15 tabs, all with similiar tables except
that
they have different numbers. I format the print area, by highlighting
selected portions of the worksheet and choosing "add to print area", but
the
problem is that I have to do this manually to each of the 15 tabs. Is
there
a way to do this automatically?
Someone said to highlight all the tabs and go into page setup, but this
does
not work since I have to use the Page Break and "add to print area" to
select
the parts I want to print.

Thanks