Set Multiple Print Areas

J

James Hamilton

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!
 
B

Bryan Hessey

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
 
Top