View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Counting string length

Try LEN, like this:


MySetLength = Len(MyArray(MySetIndex))

tod

-----Original Message-----
Hello all,

I'm trying to count the characters in an element of an

array using this code:

mySetLength = mySet(mySetIndex).Characters.Count

But it doesn't work. I've made sure there's actually

something in mySet(mySetIndex) when it crashed by removing
the .Characters.Count part, and it all checks out. Any
idea how to do this correctly?

Thanks in advance.
.