Lost Automatic Row Height

  • Thread starter Thread starter Zone
  • Start date Start date
Z

Zone

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
 
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.
 
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
 
Back
Top