Here is a subroutine that can be used to find the last cell in a sheet that contains a string.

First, make it similar to the Ctrl-F (excel default find), but more simple
Second, adjust the where...