View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
The Wonder Thing[_3_] The Wonder Thing[_3_] is offline
external usenet poster
 
Posts: 4
Default Counting string length

Many thanks to both of you. Can't believe I never found that Len() function while looking through the help. That works great.

"Leo Heuser" wrote:

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.