Copy Range with Find Function

Morning All!
I'm trying to use a find function to set a range to copy. It all runs fine when the values I search for are found, but I would like to manually select a range if the values aren't found.
So far I've come up with this, but Keep getting Error 91.. Any help?

Please Login or Register  to view this content.

One thing that may produce an error I notice is this line.

Please Login or Register  to view this content.

If "Text2" is found in row 1 or 2 it will produce an error when the code tries to offset.