Print Area

[Marianus]

Hi

a have problem I odnt know define Print area

I want Print 2 PAge

Please Login or Register  to view this content.

I want 1st page was range1 , 2nd page was range2 , my code not workin when I want, this code define new range for page1 and page2

Marianus

[JBeaucaire]

Just set the Print Area to the one range C17:AV134.

Then insert a page break at row 18.

[Marianus]

Thank you

how insert page brake ?

[JBeaucaire]

Press F1 in Excel and search for Page Break. Excel's builtin Help Files are the best starting point for questions this simple.

[Marianus]

by VBA code ?

[JBeaucaire]

Once you have found how to add a page break manually, you will be able to record yourself setting the Print Area to the one big area and setting the page break at row 18.