Hi, I have the following codes, just an example, that I use to find a word "Hello World" in an active worksheet. If it finds "Hello World", it will update cell A1 to "1000". Else, if it doesn't find "Hello World", it updates cell A2 to 2000. However, the codes breaks when it doesn't find "Hello World". How do I modify the code, so that the FIND function returns true or false or something similar, so that I can use the IF function to update the worksheet correctly.

I want a FIND function to work like this. If the worksheet has a world "Hello World", it updates cells A1 to 1000, and if it doesn't find the word "Hello World", it updates cells A2 to 2000.

I really appreciate the help. Thank you.

HTML Code: