Thanks for trying it out, Bill.

Unfortunately it does not quite get there, and the last inch is the b*gger.

The problem is that setting to a single page sets zoom to false, so the
actual zoom characteristics cannot be interrogated directly.

I have been given a couple of solutions on a rival site that I am having a
play around with. One makes use of the excel 4 macro GET.DOCUMENT(50) and
the other makes liberal use of sendkeys, so they are both pretty yucky, but
I guess it is the best available.