View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser[_3_] Leo Heuser[_3_] is offline
external usenet poster
 
Posts: 109
Default Counting string length

Hello

Try

mySetLength = Len(mySet(mySetIndex))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"The Wonder Thing" skrev i en
meddelelse ...
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.