Vba to set a print area judging where to put the page brakes by the blank rows?

[tonywatsonhelp]

Hi Everyone,
I'm really struggling with this hope you can help,
I have arrange of EB100:EJ500 where i add details of this weeks sales etc.
I want to print out the pages are very tidy looking.
after looking at my data ive realised that the best [laces to put the page breaks would be Every 64 rows

However this gives me a problem as some of my info should be read together.

so hears what I'd like to see Id Like the macro to give me an output of Page sizes so i can check what is going on,
so this is my idea

Starting at Row 100 and Using Column EC find the words "Kind regards," and add ten to the row its in, (This gives me the final row as i often don't use the entire Range area)

If Kind Regards + 10 row is less than 164 then in cell EL100put the range "EB100:EJ164" as this is the area needed,
however if the last row is more than 164 then break it up into pages using this this rule

for each sheet need to create pages of 64 or less there must be two blank rows in column EC to add the Page break

So as an example lets say the range was EB100:EJ300
first should be EB100:EJ164
but if EC164 has data in it then go to EC 163, EC 162 and so on until you find two blank cells

please help
thanks
Tony