On Aug 10, 10:11*am, Claus Busch wrote:
Hi John,

Am Fri, 10 Aug 2012 01:27:46 -0700 (PDT) schrieb Johnnyboy5:

how do I "preselect pages" * also not sure about the macro you wrote
there are a lot of ,,,,,,,,,,,, in it ,,,,,,,,,,,,,,

in "Page Break Preview" you select your pages with pressed CTRL-Button,
then choose "Set Print Area" and run the macro

Sub myPrint()
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
End Sub

Got it now, many thanks

John