In my application it's important for one worksheet to be ONLY two pages long
and yet have the row height be the maximum it can be.

I'd like to build a loop to vary the row height but can't find how to
access the page number I see in gray in the background of the page break
view. (any other page number would also be fine.)

the gist of the desired logic is: ( in 'pseudo' code)

rows("1:" & lastrow).rowheight = big_number ' to be more than 2 pages
do until pages = 2
big_number = big_number - .5
loop

If there are other techniques, as always, any help is much appreciated.
--
Neal Z