In MS Excel VBA, define a range of only those cells in a column that contain the value False
Posted on 2016-09-02
I have a sheet with data in columns A:H with ~16000 rows
H:H contains boolean values, either true or false.
All but ~100 of the values are True and those rows are of no interest.
I need to process the rows where cell H:H is false.
Traversing the full column from top to bottom is sloooooooooooooow.
Is there an efficent way to define a range of those rows where H:H = false so that my code doesn't have to deal with the values of no interest at all?
In the UI, it would be the equivalent of applying a filter, and then moving down each filtered row and executing a macro.
How do you accomplish something similar in VBA?