Sorry, my reply dropped a piece of text :

Hmmm, sort of, well, no, not really. Because the macro (attached
below) first sets printing to 1 page wide and Zoom to False, when it
then goes to find what Zoom is it get a result of False. When this is
done manually, the Zoom % figure is set to what it would need to be to
print one page wide, this is what I need to trap.

Cheers
Fred