View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default How to determine whether text in cell needs to be wrapped?

Hello -

I want to determine whether a string will fit into a column or now
(i.e. whether it needs to be wrapped or not). I looked at the WrapText
property but that is only set when the cell is actually wrapped.

Is there a way to determine a "wrap necessary" or "will be wrapped"
status? I could probably count the number of characters and make a
guestimate on the maximum number of characters that will fit into a
specified column witdh ... just not the best solution ...

Any ideas?

Thanks,
Joe