Set Multiple Print Areas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have numerous sheets in my workbook and I have to print each one of them.
Is there a way where I can automatically (VB?) set the print area for each
one, as they are of different sizes.

Thanks!
 
The easy way would be to mark each area and Insert - Name - Define for
that area.

Then to print, select the name from the dropdown, and Print -
Selection.
This does not allow you to have different Header rows though
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Area to include text box 10
Headers and Footers size 2
Need to print a workbook but worksheets have diff print areas 1
Set Print Area & print on one page 2
Setting print area for entire workbook 1
Printing Different Sections of same Sheet 1
Excel VBA - Problem with Closing Print Preview 0
Excel 2003 - Print Area different for same worksheet on different 1

Back
Top