Preventing a range to be split on two pages A4

[cvelle89]

Hi again,

Does anybody know how to do this?
I ve tried with property

Please Login or Register  to view this content.

But it isnt a table, just few cells, some of them are merged unfortunately..

Logic should be, if there any room for all twelwe cells on paper put it there, else copy on the begining of new a4 page.

It would be for i=1 to 'as much pages is created. The text above will generate automatically from userForm..

Please find attachment below.

Thanks!

[xladept]

Hi cvelle,

You can play around with this code - you may be able to get the result you need:

Please Login or Register  to view this content.

[xladept]

Hi cvelle,

Thanks for the rep!

Is this thread solved? What code did you finish with?

[cvelle89]

xladept,

The code was helpful, I am on the right way to sort it out :D

Thanks!