Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting string length
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero length string on chart | Charts and Charting in Excel | |||
Zero-Length string vs Zero (also a valid value) | Excel Worksheet Functions | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
Finding cells of different string length. | Excel Discussion (Misc queries) | |||
String length | Excel Discussion (Misc queries) |