ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing Copies based on Label Caption WONT Work, WHY is it Soo? (https://www.excelbanter.com/excel-programming/388261-printing-copies-based-label-caption-wont-work-why-soo.html)

Corey

Printing Copies based on Label Caption WONT Work, WHY is it Soo?
 
With Sheets("Data")
..Select
..PrintOut From:=1, To:=Label2.Caption, Copies:=Label5.Caption
End With

The Page from and to works fine.
But why does the Copies NOT ?

Corey....



Norman Jones

Printing Copies based on Label Caption WONT Work, WHY is it Soo?
 
Hi Corey

I could only reproduce your problem if the value of
Label5's caption was not numeric.


---
Regards,
Norman


"Corey" wrote in message
...
With Sheets("Data")
.Select
.PrintOut From:=1, To:=Label2.Caption, Copies:=Label5.Caption
End With

The Page from and to works fine.
But why does the Copies NOT ?

Corey....






All times are GMT +1. The time now is 04:43 AM.

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