I don't want to search for a value just after a cell, or before that. How could I perform that?
The value of A10 is in Cells of B1, B3, B7, and B16 too.
If I search for the value of A10, then i don't want to get B16, because it looks for the value with a direction of "xlNext". I need B1...