Search words in array?
 

Hello,

Can you help me out with this problem:
I have an array DXF with m elements. In these m element are differen
numbers and also words. I want to count (find) all the words LINE i
this array. Why this procedure want work:
…
For i = 1 To i = UBound(DXF)
If DXF(i) = "LINE" Then
n = n + 1 ‘n=number of words LINE in array
End If
Next i
…

Or if I turn my question little different:
How can I search for perticular words in array?

Thank you in advanc

--
Dr.Il
-----------------------------------------------------------------------
Dr.Ile's Profile: http://www.excelforum.com/member.php...fo&userid=1597
View this thread: http://www.excelforum.com/showthread.php?threadid=53254

Search words in array?
 

Dr.Ile,
Depending how your array is created, is the lowest index = 1 ?
For i = LBound(DXF) To i = UBound(DXF)

How does this "not work" ?

NickHK

"Dr.Ile" wrote in
message ...

Hello,

Can you help me out with this problem:
I have an array DXF with m elements. In these m element are different
numbers and also words. I want to count (find) all the words LINE in
this array. Why this procedure want work:
…
For i = 1 To i = UBound(DXF)
If DXF(i) = "LINE" Then
n = n + 1 ‘n=number of words LINE in array
End If
Next i
…

Or if I turn my question little different:
How can I search for perticular words in array?

Thank you in advance


--
Dr.Ile
------------------------------------------------------------------------
Dr.Ile's Profile:
http://www.excelforum.com/member.php...o&userid=15975
View this thread: http://www.excelforum.com/showthread...hreadid=532541