ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing (https://www.excelbanter.com/excel-programming/307056-printing.html)

Caroline vincent

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.


All times are GMT +1. The time now is 08:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com