| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| label caption | Excel Discussion (Misc queries) | |||
| Label Caption Problem | Excel Programming | |||
| Label - Caption not changing | Excel Programming | |||
| Label Caption Just Wont Work on UserForm | Excel Programming | |||
| label caption | Excel Programming | |||
Linear Mode
