First of all, I don´t want to use nested For-loops, because I read that these would become slower with bigger amount of data (n can be up to 10k). So, now, I have an array arrData(n,2), while n is variable, and I want to go through this array per row, using the for each statement.
So here is my c...
I can conceive of looping a single dimension array as being faster than looping a multidimensional but if both contained the same number of elements and the count was very large would it be noticeable?
First, let's address this misconception:
I read that these would become slower with bigger amount of data (n can be up to 10k)
This is simply not true. Multi-dimensional arrays are only "slower" than single dimensional arrays because the memory address of the indexer has to be calculated (m...
First, let's address this misconception:
I read that these would become slower with bigger amount of data (n can be up to 10k)
This is simply not true. Multi-dimensional arrays are only "slower" than single dimensional arrays because the memory address of the indexer has to be calculated (m...
VBA Rubberducking
VBA Rubberducking