Merging a page of a sheet with a sheet and printout

[hemis]

Hello

I want to merge a page of sheet1 with the whole of sheet2 and printout using vba.

The code I have written is

Sheets(Array("Sheet1.page(1)", "sheet2")).Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

If the array reads Array("Sheet1","Sheet2") then printout works.

Any pointers to how I can select a page and worksheet and merge at printout.

Regards

 

[SpillerBD]

You can print multiple sheets as the selected sheets. What is printed from each sheet would be managed with the Print Range definition for each sheet.