Hi

Im programming in VBA Excel 2007 :

Example :
a: x
b: 1
c: 1

a: x
b: 2
c: 2

a: y
b: 1
c: 2

The values a-c are in Column A and values "x,y,1,2" are in Column B

What I want to do is find "x", if x's found i want b.value to be 2 for it to continue with the rest of the function. If not, keep looking for the next x

I've tried working with the method .find which finds "x" and then i use a do - statement which searches for the next "x" while b.value <> 2

But that doesn't seem to work

Any suggestions?