It'll also throw an error if Sheet1 is not active and the Find succeeds ...

Do as I said - assign the results of the search to a Range variable.
If the range is not nothing after the search then ensure the range Parent sheet is active before selecting the range