Thread: Array Question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Array Question

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?