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

"Frank_Hamersley" wrote in message ...
"Paul Robinson" wrote
This works reasonably well for me. Overdoes things a bit for small
tables. Operates on the UsedRange of the ActiveSheet.

'Simplified version of a function written by Francois Van Wauwe,
Microsoft.Public.Excel.Programming, 25th Sept 1998

This is nice and deterministic. Many thanks!

Frank.