Printing Multiple Worksheets

G

Guest

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
 
B

Bob Flanagan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

operate macro across multiple sheets, error, cannot locate solutio 3
Syntax to match sheet by codename 4
Run-time error 91 Object variable [2003] 2
Enable groups on a protected sheet 4
Compile Error: With From:= << Highlighted 9
Reference a workbook level named variable. 8
Split function - assign to array 2
Code Works Fine in Excel 2007, Excel 2000 generates Runtime Error 438 0

Top