Mike,
The code does work for the value, I do want to be able to return to the cell that is why I wanted the cell address in column 2, but I don't have the vba skills to write the code, can you please help as that's teh main bit that I want, the ability to go to a cell.