Printing

C

Caroline vincent

I would like to always print only c5 and only F9:M9 with
the range I am selecting for priting. How can I do that?
for the moment if I write
.....
If PrintSmokingForm.Step1.Value = True Then
Range("c5", "printstep1").PrintOut Copies:=1
Else
If PrintSmokingForm.Step2.Value = True Then
Range("c5", "printstep2").PrintOut Copies:=1
Else
.....
it prints all areas between c5 and my "printstep1" area.

As always thanks in advance.
 
T

Tom Ogilvy

If you want these to appear on one printed page, you will need to print as
you are doing now, but hide the rows and columns you don't want to appear in
the printed page.
 
C

caroline vincent

Thanks.
While you are around....could you answer this one too?
And if I want to print the name of the sheet on all
printed pages?
Thanks
 
T

Tom Ogilvy

In Excel 2000 at least, if I go into View=>Headers and Footers, then create
a custom footer (or header), the last icon on the right inserts the tab
(sheet) name in the footer &[tab]

So I would just set up a custom footer or header.
 
C

caroline vincent

Seems obvious...
Thanks a lot
-----Original Message-----
In Excel 2000 at least, if I go into View=>Headers and Footers, then create
a custom footer (or header), the last icon on the right inserts the tab
(sheet) name in the footer &[tab]

So I would just set up a custom footer or header.

--
Regards,
Tom Ogilvy

Thanks.
While you are around....could you answer this one too?
And if I want to print the name of the sheet on all
printed pages?
Thanks
Click to expand...
wrote in message
Click to expand...


.
Click to expand...
 
Top