View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default Trim Difficulties

Hi Will,
For Each i In MyRange

mystring = ActiveCell
trimstring = Trim(mystring)
MyRange = trimstring

Next i



for each i in myrange
i = trim(i)
next


arno