Set Multiple Print Areas
 

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=381095