I am trying to find Areas in each row, looping one row at a time, which are separated by values that are less than a certain value, say, < 3. Then find the largest Area that has count of cells >= 6 and set it to a range object. Then i want to find the corresponding start and end dates of this range from the 1st row.
I donot want to loop the cells in each row and check cell's value if it falls below 3. Is there a quick and efficient way to achieve this using VBA without looping the cells in each row?
