"Paul Robinson" wrote
Re-reading your original mail, this function only fits to 1 page, so
isn't quite what you wanted. Should be adaptable though?

Certainly was - and works very nicely.

Whilst I was working on this it occured to me that Excel doesn't handle
wide+shallow or narrow+deep reports in a very environmentally friendly way.

What it needs is something like multiple pages on a single akin to Word
multi column pages - ie. basically to optimise/minimise the amount of white
space on the page.

Given the number of pages imaged today and everyday even a simple
improvement might save a lot of trees!

Cheers, Frank.