Thread: Printing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Caroline vincent Caroline vincent is offline
external usenet poster
 
Posts: 9
Default Printing


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.