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
|