Sure

Change the 1 to "yoursheetname" (with the "" )

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Darin Kramer" <darin_kramer@hotmail.com> wrote in message news:%23rNES$OzFHA.664@tk2msftngp13.phx.gbl...
>
> Thanks Ron, - Can i not specify the name of a sheet to be printed as
> opposed to the first sheet in each book ?(Users may have moved the order
> of the sheets around a bit)
>
> Regards
>
> D
>
>
> *** Sent via Developersdex http://www.developersdex.com ***