Help finding a tutorial/guide for searching VBA Arrays

Hi all,

I'm looking for a tutorial/guide to help me searching within an array (and then assigning to a variable). I've done a few google searches, but I'm struggling to find what I'm after.


essentially I have an variant array (1 to 4776, 1 to 22), I want to search it for values, conditionally... for example, imagining it as a table, i'd do "countifs" to find what I need, but I'm not sure how to do that within an array.


If someone knows of a guide/tutorial, or even the words I need to search this for myself, that would be awesome, but I'm either finding guides on creating arrays, or how to create Array Formula in excel.


Thanks in advance,

Tim

Originally Posted by rorya

It sounds like you just want For...Next loops to loop through each 'row' of the array - eg

Please Login or Register  to view this content.

HAHAHA! It's starting to look like I've been overthinking this! Thanks Rorya, I'll give that a go and let you know how I get on!

as @rorya said 'good old fashioned loops' I have attached the method I have used on numerous occassions.
rather than find what you want, it works by eliminating what you do not want, it fills the unwanted rows with 'emptiness' then eliminates them leaving an array meeting your requirements.
The attached file was used to prove that data sorting speed would still be effective with 10years worth of data present, the first 20 rows are the array 'seed' put a figure in N4 (say 50,000) press fill array when filled press sort - this gives the speed it took to produce the 'invoice data' & 'transaction history'
Hope the approach and code is of some assistance.
torachan.

Thanks Torachan, i'll take a look at this!

Right, loops are working fine, no idea why I didn't even consider this! Torachan, I'm not going to get time to look at this during this project, but I've saved the file and wanted to thank you for giving me the suggestion.