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