I have a issue. I have a lot of rows. What I need:
There is a flag column myCol_Flag, that has 1 in certain rows, so the vba will get the row numbers for those flagged with 1 and store in a variant array or some structure and then I will be able to do something like
For n = LBound(varData, ) To UBound(varData,)
Do something to the row
The flagged rows in this example are 6,7,14,18
So I will need to go through only the flagged rows to do my stuffff
How do I set up the loop to take into account only the flagged row number?