VBA code to set out page print layout - height automatic

as mentioned in the topic, I recorded a macro while setting a page layout, the only thing I've changed is page height to 'automatic'; the code that I get is the following:
(please note that there were some other changes in printing properties before)

Please Login or Register  to view this content.

how to take out only the small part of code that is responsible for changing the property mentioned in the topic? Is that possible at all? thanks for your help.

Hi,

The part that is responsible for making the height automatic is

Formula:

Please Login or Register  to view this content.

So your code in its entirety would be

Please Login or Register  to view this content.

Hope this helps

Thanks, I put this line to the code mentioned in my first post and it works:

Please Login or Register  to view this content.

You're welcome!

Please don't forget to mark this thread as solved