View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TroyH TroyH is offline
external usenet poster
 
Posts: 9
Default 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