VBA to bypass Page (Manual/Automatic) breaks !

[ionelz]

I want to create a PDF for a dynamic range : (from B2 to 2+N3 / B+N4
But my page breaks take control of this
How can I bypass them so I can create all in one page
Also in formula manager I get printa area variable at each pdf creation !

Please Login or Register  to view this content.

[ionelz]

Maybe someone could help on this !

[LJMetzger]

Hi ionelz,

Try the following code to print all on one page. Changes to your code are in Red:

Please Login or Register  to view this content.

Lewis