View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tempy Tempy is offline
external usenet poster
 
Posts: 203
Default Set Column width

Good day,

I am recieving a spreedsheet that is set up programmatically in Germany
and the columns are set to certain widths and this is causing problems
when doing a count for names in the column. The column is set to 30
characters and Text; if i have the name "Nel" with a look up it does not
see it as i do not have the spaces ?

If i use the name "Nel" & "27 spaces" then it finds it ?

Could i please have some advise on how to rectify this as i have names
varying in lenght.

Thanks

Tempy

*** Sent via Developersdex http://www.developersdex.com ***