The array can have any values you want, with wildly different ones you would
typically dim it as Variant. as far as finding, there are ways, but the
system can probably loop through your array just as fast.
do until myArray(myindex,1)=cells(1,1)

myindex=myindex+1
loop
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Mike H." wrote:

I populate an array from data in a text file. Then I go to a spreadsheet and
I look at a cell and want to find the text in that cell in the array. Is
there an arrayfind() function to find the data that is in the cell? And can
I sort the array so that the find is faster?

Also, I populate a similar array with values. Can I have both types of data
in one array, text and values?