On Jul 21, 9:51 pm, "Jim Cone" wrote:
You can add the number of the starting page and ending page to your code.

From the Excel VBA help file...
"expression.PrintOut(from, To, Copies, Preview, ActivePrinter, PrintToFile, Collate)"

So your code would look like this to print pages 2 and 3...
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=3, Copies:=1, Collate:=True
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



<Snip

Thanks Jim. As usual I didn't read the help file sufficiently to see
the answer was right in front of my face!

Your help is very much appreciated.

Dooley