AutoHeight is one of those features that just doesn't co-operate unless
everything is right with font size, cell width, and screen resolution.

I use Excel to author instruction manuals (via templates) that contain
text, images, and tables. It was as frustrating as heck to get things
so that the printouts matched what I saw on the sheet (WYSIWYG). Now
that I have that behind me, page layout is only a matter of setting
page breaks how I want them.

Also, I use bottom alignment for paragraph type content and center/top
as appropriate for captions/side notes. Like you, I played with
top/bottom alignment and found bottom to be the most reliable
(results-wise), and RowHeight is a given number of pixels per line of
text with first line having the desired spacing added to offset
appropriately from the previous text.

In summary, you need to figure out for a given screen resolution what
width is required for your cell[s] to display its text as it will
print. Printer margins also come into play and so have to be factored
via lots of print previews until you get it right. Once there, save the
sheet as a template. I keep all such templates in a single workbook and
just copy the one I want to my project file.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc