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?
Bookmarks