I have a sheet which can have anything between approx 50 or 100 rows of data,
controlled by formulae which will leave the cells blank where no data is
required. I want to print it all on one page but am having problems with
leaving large blank areas at the bottom of the page if a low number of rows
are shown.

Rather than always setting the print area to the maximum that will ever be
required I want my macro to set the print area to show only the non-blank
rows. As some cells within the range are blank anyway I can't simply count
the non-blank cells and do it that way.

Any ideas? (I'm not very good at programming so if you could explain any
solutions I would be very grateful!)

Thanks

Phil