I sometimes use the code  below to look for a cell. It's based arounf the VBA
"Find" which is well documented in the help.
It returns a "range", which you can then do things with including going to
it and getting it's address.

You'll see that I've included a second "parameter" for the function. If the
parameter isn't given then it will default to the first found, Otherwise it
will loop around finding the Nth occurence of the search  string.

If the search string isn't found  at all then it gives a message... "Not
found".

You could call this from a sub.... Something like...

Sub subFindAndGetAddress()

Dim rlFound as range

Set rlFound = fncLookForCell("Search String")
rlFound.Select
MsgBox rlFound.Address

End Sub

This is an example but should give  you something to bite on.