Hi Guys,

I was wondering if anyone can help me I was wondering how I would set up a variable that would determine the amount of cells to check for in a range depending on the value entered into a Cell

So if Value X Was entered into Cell A1 it would Check For 2 occurrences of A Value
And If Value Y Was entered Into Cell A1 It would Check For 1 occurence of The Same Value?

I appologise if this is vague but am trying to learn how to implement new variables into a subroutine and am really struggling.

many thanks

jamie