View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Mulroney[_3_] Robert Mulroney[_3_] is offline
external usenet poster
 
Posts: 71
Default Detecting if a value "fits" in a cell.


Is it possible to detect if a value is being fully displayed in a cell? I
want to resize a cell so that text won't flow over adjectent cells and
numbers don't display as the ##### thing. To do that I need a check to see if
the value fits in the first place.

I have a report where users are being asked to comment on financial
preformance. As always my users don't want to play ball, and we can't agree
on how big the comment cell should be. I'd like to be able to grow or srink
it depending on the comment provided.

no replys about srink to fit and word warp, please.


- Rm