-
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.
collate=true
-
S
Printing excel worksheets using VBA macro
Hei guys, I have an excel workbook which contains worksheets, say, W1 to W9. I recorded a macro to print the sheets and it is working fine to certain extent. The code is like this: Sub Macro1() Sheets("W1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=3, Collate:=True, _...- srinimtech
- Thread
- code collate=true end ignoreprintareas=false sheet
- Replies: 1
- Forum: Excel Questions
-
S
Printing excel worksheets using VBA macro
Hei guys, I have an excel workbook which contains worksheets, say, W1 to W9. I recorded a macro to print the sheets and it is working fine to certain extent. The code is like this: Sub Macro1() Sheets("W1").Select ActiveWindow.SelectedSheets.PrintOut Copies:=3, Collate:=True, _...- srinimtech
- Thread
- code collate=true copies=3 ignoreprintareas=false sheet
- Replies: 0
- Forum: Excel Questions
-
M
Macro to prompt for which printer to use
Currently have a macro to instruct for the print the workbook sheets as follows, but I am lokk9imng for a code that would prompt to select which printer to print, can anyone help? Sub Macro2() ' ' Macro2 Macro ' ' Keyboard Shortcut: Ctrl+Shift+P ' Sheets("Charge Sheet").Activate...- Mcfg007
- Thread
- collate=true ignoreprintareas=false macro macro2 print
- Replies: 3
- 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
