Number of rows in an array?

KippSmith
03-15-2003, 07:46 AM
See subject

Dim Hello
Hello = Array("I", "say", "hello")
MsgBox Count(Hello)

That doesn't work :p

Flyguy
03-15-2003, 08:03 AM
What is "Count" ?

Deadalus
03-15-2003, 08:51 AM
To get the total number of rows in an array, you can use the Ubound function.
To find the place of a specific item, you'll have to loop through the array.

Iceplug
03-15-2003, 08:58 AM
The number of elements in an array can be found by
UBound(thearray) - LBound(thearray)
This depends on the lower bound, as you can see....
You should also declare your array
Dim Hello() As String

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum