Greetings everyone!

I have an error message that I am having a hard time getting rid of. The code is throwing the following code: "Runtime error 91. Object variable or with block variable not set." I have adapted this code for use in a project and I cannot seem to get the code to work. I would request that someone take a look at the entire code to see what I have done wrong. This code, once completed, should search G12:G. I need for all aspects of this code to work. Thanks in advance for your assistance with this!

I have attached a sample file to illustrate the problem.

David