I have created spreadsheets, to list students and their data, that have to be
updated weekly. The lists have to be printed as well. To keep the width
within one page, the font has to stay at 8 pts. For ease of reading, each
record alternates color from its "neighbors". I have created macros to
reshuffle the colors after I resort names when new ones are added in, since
the color of the records follows the name to its new row. I have a value of
40 for the height of the rows that is mostly adequate. The problem comes from
a wrapping memo field within each record that may increase the height of the
row to above 40 pts. When I re-sort the list of names, the macros take care
of the colors, but the height of the rows stay put; that means that some
records that could use more space in the memo field get cropped off, while
some that do not need the space may now be located in a row that is too high.
The autofit function works for this problem, except that it "squishes" the
data, so that it becomes less easy to read. What I would like to do is to be
able to use the autofit function, but also to put a minimum of 40 pts height
per row. Is that possible?