Setting print areas on many sheets

  • Thread starter Thread starter arunsharm82
  • Start date Start date
A

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
 
arunsharm82 said:
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
Click to expand...

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