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,