View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Counting string length

Try

mySetLength = Len(mySet(mySetIndex))

In article ,
"The Wonder Thing" wrote:

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.