bloodmilksky
01-09-2017, 05:53 AM
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
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