| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help w/ Print Macro to Print All Visible Sheets (including Charts) in a Workbook
I thought that this would do it but it is giving me an error of:
1004 Methough PrintOut of object Sheets failed Sub PrintMacro() vCopies = InputBox("How Many Copies?") i = 1 For i = 1 To vCopies Sheets.PrintOut Next i End Sub Any help is appreciated Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print Visible Sheets Macro | Excel Discussion (Misc queries) | |||
| Print embedded charts from several sheets | Charts and Charting in Excel | |||
| Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
| Spreadsheet print including macro buttons? | Excel Discussion (Misc queries) | |||
| macro to select sheets/page in a workbook and print them | Excel Programming | |||
Threaded Mode
