![]() |
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.... |
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