Lost Automatic Row Height
 

Using VBA, I set the size of all the rows on my worksheet to 12.75.
Now, when I format a larger font size, the row height does not increase
the accommodate the larger text. Yikes! How do I get back the
automatic height? TIA, James

Lost Automatic Row Height
 

Try autofitting the the rowheight again.

If you explicitly set the rowheight, then excel knows that you don't want it
changed.

By autofitting that rowheight, excel knows that you want its help.

In code, you'll have to autofit that rowheight after the font change--or stay
away from changing the rowheight yourself.

Zone wrote:

Using VBA, I set the size of all the rows on my worksheet to 12.75.
Now, when I format a larger font size, the row height does not increase
the accommodate the larger text. Yikes! How do I get back the
automatic height? TIA, James

--

Dave Peterson

Lost Automatic Row Height
 

Many thanks, Dave. That did the trick. I had set all the rows to
12.75 to get them back to the "default" height after I cleared them.
Now, after I clear them, I just invoke autofit. Works perfectly.
Regards, James

Dave Peterson wrote:
Try autofitting the the rowheight again.

If you explicitly set the rowheight, then excel knows that you don't want it
changed.

By autofitting that rowheight, excel knows that you want its help.

In code, you'll have to autofit that rowheight after the font change--or stay
away from changing the rowheight yourself.

Zone wrote:

Using VBA, I set the size of all the rows on my worksheet to 12.75.
Now, when I format a larger font size, the row height does not increase
the accommodate the larger text. Yikes! How do I get back the
automatic height? TIA, James

--

Dave Peterson