Setting print areas on many sheets

[arunsharm82]

Hi

I would like to know if there is a way of easily setting the print
areas in a workbook automatically.

Basically I have a spreadsheet with around 30-50 tabs, depending on
what comes in during the week.

I need a method of automatically setting the print areas to only select
the cells that have data in them, for each tab.
Currently I have to go in each one and do it manually, and this takes
ages.

Could anybody suggest a formula or VB code for me to use?

Thanks

 

[Paul]

Hi

I would like to know if there is a way of easily setting the print
areas in a workbook automatically.

Basically I have a spreadsheet with around 30-50 tabs, depending on
what comes in during the week.

I need a method of automatically setting the print areas to only select
the cells that have data in them, for each tab.
Currently I have to go in each one and do it manually, and this takes
ages.

Could anybody suggest a formula or VB code for me to use?

Thanks

Why bother setting them at all? If no print area is set, Excel will
automatically choose just the area containing data.