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
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