I need help changing a current module I've found online, this module counts unique visible cells in a range, and I would like to change it to count unique visible cells in a range according to an criteria, the thing is the criteria is a different range (1 column to the left of rng in the function).
Want to change it to:
Can I iterate on more than 1 range in the same loop? like rng1.Next and rng2.Next in the same loop?
Cause I tried to add a 2nd range to the function and tried to make it iterate on both ranges as but it didn't work.
Just to make things clear this a #c code to explain what I want to do
I know c\c++ & java but never tried VB which seems like a mess, I've tried to describe my problem the best I could, I hope its understandable.
Any help will be appreciated.