Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Multiple Worksheets
Why does this not work
Private Sub PrnSheet_Click( Dim Sht As Workshee For Each Sht In ActiveWorkbook.Worksheet Sht.PrintOu Next Sh End Su I keep getting the error Run-time error '1004' Method 'PrintOut' of object '_Worksheet' failed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Multiple Worksheets
Is one of the sheets empty? You can determine which sheet it is by setting
a watch on Sht.Name. Bob Flanagan Macro Systems http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "TroyH" wrote in message ... Why does this not work? Private Sub PrnSheet_Click() Dim Sht As Worksheet For Each Sht In ActiveWorkbook.Worksheets Sht.PrintOut Next Sht End Sub I keep getting the error: Run-time error '1004': Method 'PrintOut' of object '_Worksheet' failed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
duplex printing multiple worksheets | Excel Discussion (Misc queries) | |||
Printing multiple worksheets. | Excel Discussion (Misc queries) | |||
Printing Multiple Worksheets | Excel Discussion (Misc queries) | |||
Printing Multiple Ranges from Multiple Worksheets | Excel Programming |