Gord, Thanks for responding. On the work sheet "sheet 1" I have 3 sections
that when I print, prints out in 3 pages. I tried the setb printb area as
suggested an it worked great. will this also work when I select "send to
email reciepient as an attachment" as well

"Gord Dibben" wrote:

What do you consider as a "page"?

A range on a worksheet that fits on one printed page?

You could give that range a name then assign it to a print macro or just select
the range and FilePrintSelection.

Or a particular worksheet to print?


Gord Dibben MS Excel MVP


On Tue, 12 Dec 2006 10:00:00 -0800, zchuckz
wrote:

I have written a few programs. The problem is I want to be able to control
what page in the workbook gets printed.