Adjust page breaks

Dear, good afternoon.

I wonder if a macro is possible to adjust the page breaks according to the total height of the lines. For example:

The first page like the page break occurs from 971 high (ie, page 970 would go to a high total) from the second page break from 946 would be high (ie, the second page on pages 945 would total height).

Looking forward.

hi

Any idea?

I will express myself well?

I would be very happy if someone could help me on the subject, thanks!

would be very happy if someone could help me on the subject, thanks!

hi

Any idea?

I will express myself well?

I know someone will respond with a good heart
Thank you!

Do you mean to adjust the page break to the total of written lines in the sheet?

thanks for replying!
Yes!
send me an example

Do you want to adjust the horizontal page break only? Or the vertical one to the number of columns too?

Adjusting the horizontal and vertical

It has to be according to these criteria.

I wonder if the macro is Possible to adjust the page breaks According to the total height of the lines. For example:

The first page like the page break Occurs from 971 high (ie, page 970 would go to a high total) from the second break from page 946 would be high (ie, the second page on pages 945 would total height).

Does the code I provided not work?

Erro 9.
You Can Do with the criteria that is in the post above?

It worked but I needed it to put the criteria in the post above.