Search Range for matching value return and to active cell.

I am trying to search for a value in column B in column A. If the value is not found then move to the next cell in column B but if the value is found then return to same cell in column B.

This code works half way. If the value is not found in A it will move down to the next cell in B. but if the value is found in column A it will move down to the next cell in column A. I cannot figure out why. Any help would be appreciated.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

INTO

Please Login or Register  to view this content.

I have used that and it will return to Column B if the value is found but will not drop down to the next cell if the value is not found.

Because your search does not have a Find(Next) function built on it.

That doesnt quite accomplish what i want. It is like whatever i have as my else statement doesnt function.

If anybody is still reading this thread I have figured out what the problem was.

Basically all i did was remove "test1" and simply replaced it will selection. granted this code is pointless but it was move of a proof of concept. my untimate goal was to have the found values deleted. here is my final code.

Please Login or Register  to view this content.

I am going to add a loop so it keeps running until the "selection" in column B is empty but it is lunch time and I am hungry.