-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copies=1
-
B
VBA Printing Preferences Help
I have the code below in a userform that I need a little help with. I need the code to have like black and white, 11 x 17, zoom 90, landscape, print range and also I need it to go to a specific printer. Im not really sure how to get any of that information. Thanks as always for the help...- bamaisgreat
- Thread
- code copies=1 end printing true
- Replies: 3
- Forum: Excel Questions
-
B
VBA to print pages depending on option button
Hi all, Appreciate any help to make below work: Private Sub CommandButton1_Click() Dim wks As Worksheet Set wks = Worksheets("FQF") With wks Select Case Frame1.ActiveControl.Name Case OptionButton1 'This is the name of the optionbutton...- bademployee
- Thread
- case copies=1 end print wks
- Replies: 2
- Forum: Excel Questions
-
S
Macro - Update Info and Print out
Hello Mr Excel, I recorded a macro to print individual scorecards for six people. I have to get the name into cell C12 to update the information and then print the scorecard. Am I able to automate this macro to allow it to print more than six names and stop at the end of the last name (stop at a...- SaiChu
- Thread
- activecell.formular1c1 collate=true copies=1 ignoreprintareas=false rangec12f12.select
- Replies: 0
- Forum: Excel Questions
