Good Afternoon.

I am trying to write a macro to insert a page break above a data set. However the data sets are of varying rows and so a simple insert every ... rows isnt going to work.

I'm looking for a "look up, check empty code"

Best description I can give is
If text in column C and no text in columns D-I insert page break above.
The other difficult condition is that I want to the page breaks to fall as close to every 54 rows as this is how many rows I get per page.

I'm quite new to VBA and any assistance would be greatly appreciated.

Cheers
Andy.