Thread: Printing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Printing

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.

--
Regards,
Tom Ogilvy

"Caroline vincent" wrote in message
...

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.