View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] poptcat@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Compute length of a string in points depending on current font

Hi.
I have to compute the length of a string in order to achieve the best
fitting inside a cell.
So given a range of merged cells or a single cell I want to resize the
range to get the whole text visible. Without using wrap or shrink.
I can't get a good aproximation for all fonts. For example, using x as
the average char, I can't write Verdana.
No need to mention I didn't find any resource on this matter.
Does anyone know how to solve it?
Gabi