How to go threw entire spreadsheet and check for certain word in cell

[behnam]

can anyone give me a code that checks if anycells in the spreadsheet have the word "complete" in them, if not it returns false to a defined variable

[Mordred]

Please Login or Register  to view this content.

[behnam]

thanks, so much i gave you reputation you deserve it

[Mordred]

Thanks behnam, I'm glad it worked for you.

[behnam]

One quick, question. How can i modify the code so it only checks the cells in columns a-z, nothing more, thanks.