Hi flop
Try this
Sub test()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
If sh.Name < "Sheet A" Then
sh.PrintOut
End If
Next
End Sub
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Flop" wrote in message ...
Hi:
I am trying to write a macro that will print the entire workbook except for a sheet by a certain name of "Sheet A"
How can this be done? I have a general idea that a loop will be created and then a If/then command but am unsure of what the
proper syntax would be.
Any suggestions/help is appreciated.
Thanks,