View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thomas donino thomas donino is offline
external usenet poster
 
Posts: 89
Default determine max characters in a range

I have a named range which is 10 columns wide. Is there any way to
determine, based on the font type and size what the maximum character length
is so I can test the string to be inserted into it to ensure it is not to
large?