changing a current mod (count unique visible cells ->count unique visible cells criteria

Hi,

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).

Original Code

Please Login or Register  to view this content.

Want to change it to:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.