How can i hide unused rows with a macro

[tonywatsonhelp]

Hi Everyone,

I have A sheet call invoice

In it i type my invoices but i want to hide unused rows but so the pdf looks nice,

So heres what i need,

A way to hide unused rows but leaving space if the unused part is smaller than sheet

So think of it this way,

The area I need to hide is between AC71 and AC233 (i want the row hidden but this is the columns that wil be used or empty.

Now my Page sizes are this
Page 1 AC50:AC110
Page 2 AC110:AC170
Page 3 AC171:AC250 (i might need to play around with these sizes)

So what i want is this

If Used area of range AC71 and AC233 is less than AC71:AC110 then hide AC111:AC233

If Used area of range AC71 and AC233 is less than AC71:AC170 but more than AC110 then hide AC171:AC233

else unhide all

any ideas how something like this could be done?

Thanks

Tony