THenr and Sheloo. Thank you so much for responding. The Autofit Row Height
is exactly what I need, but I will also save the macro for use with another
spread sheet that I have. Thanks to you both.
David

"THendr2929" wrote:

In Excel 2007, highlight the cells, column or entire worksheet where you want
the row height to adjust. On the Home tab, in the Cells group, click Format.
Under Cell Size, click Autofit Row Height. (Taken from Excel 2007 Help
under "Change the row height to fit the contents".)

Your row height will automatically adjust to fit your cell contents.

"dhstein" wrote:

I have a cell that may have no data or from 1 to 6 lines of data. Is there a
way to make the Row Height conditional based on the number of lines of data
in the cell? Thanks.