Find Function will only run once and then get error 91

[davidhale87]

I have a very simple code that I am trying to get to work, but for some reason it will only run once. Then I have to shut down excel and wait an hour before it will run again. I was wondering if anyone else has had this problem. I was also wondering if I can use a variable in the following code. It is pulling a date off of the "setup" page. And then looking for it on another page. I would like to change Sheets("Setup").Range("s7") to a variable so that if it does not find the date I can subtract a day at a time until it finds the correct day. Any help would be much appreciated. Thanks.

Please Login or Register  to view this content.

[protonLeah]

Without more information, maybe this will help:

Please Login or Register  to view this content.

[davidhale87]

That worked great. Thank you