In the routine for each print button you can have a line such as below with
the range of page 1 spelled out etc.

ActiveSheet.PageSetup.PrintArea = "$A1:$G30"

A new section with its own print button would require a new sub with the
print area defined for it. This is my understanding of it all and could be
proven wrong by someone more knowledgeable than I.

--
Best wishes,

Jim


"demingm" wrote:


Looking to do a relatively (well, not for me anyway) easy print button
macro that is a little intuitive. I have a sheet in a workbook that is
divided into multiple sections, with each section being an extra copy of
the one above it (format and size wise) with some slightly different
data in it. At the uppermost left of each section, I want to put a
print button macro that will only print that specific section and not
the other sections below or above it. Also, I want the ability to copy
and paste a section (including the print button macro) and have the
button properly print the new section I created. Is this possible?
I'm guessing it is, but I'm relatively new to creating macros. Please
point me in the right direction. Thanks!


--
demingm
------------------------------------------------------------------------
demingm's Profile: http://www.excelforum.com/member.php...o&userid=37901
View this thread: http://www.excelforum.com/showthread...hreadid=574336