View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Michl John Michl is offline
external usenet poster
 
Posts: 81
Default Font adjusts to size of cell

I wondering if anyone has any ideas on automatically changing the size
of a font to adjust to the size of a cell. I'm thinking something
like...

If Length of cell contents < x then adjust font to fit on one line
If Length of cell contents x but then adjust font to maximize on two
lines

All, of course, without increase the row height.

Thanks

- John