A quicker way to use a loop

Hi

Hope you can help.

I am wondering is there a quicker way to use a For loop as below, maybe a For Each? I am not that good with looping and your advice would be greatly appreciated.
I use a for loop as each row in the sheet is assessed with a condition but this is a double check that not every row would contain a NOT AVAILABLE.

Please Login or Register  to view this content.

No need to select...

Please Login or Register  to view this content.

Thanks cytop. Good tip.

This still loops row by row. What i was wondering is I have 30,000+ rows and maybe only 1,000 have NOT AVAILABLE. Is there a more efficient way to do so, maybe not?

bkeat, you could try a For each loop on a range. I'm not going to say one way or the other if it is faster than what you have, but there are definitely situations where either one may come out the winner. If you really don't want to iterate through every row, you could do something like have your code filter for values, then update those cells, but, behind the scenes, the compiler is going to have to loop through each row anyway to apply a filter.

Please Login or Register  to view this content.

Greg

Hi, check out the three articles here

Hi,

a quicker way is to use a filter to search the "Not Available" cells …