| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Array for hidden sheets using VBA
Is it possible to print multiple hidden sheets using the array function in
VBA? Currently my code opens them all up, prints, then closes them. However this is quite slow and I don't really need, or want, to see the sheets. Something like... With Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4", _ "Sheet5", "Sheet6", "Sheet7")) .PrintOut Copies:=1 End With Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Print Array for hidden sheets using VBA | Excel Discussion (Misc queries) | |||
| Print Array for hidden sheets using VBA | Excel Discussion (Misc queries) | |||
| Creating an array of sheets to print | Excel Programming | |||
Linear Mode
