Need Desperate help on my loop. Keep getting same error....

[copleyr]

Hello,

I need my macros to search for the word "Cancel" in columns "T". Once found, I need the macros to make that entire row a certain pattern ( .Pattern = xlGray16)

There will be other wording in these cells that contain "Cancel" or "Cancelled".

A compile error keeps occurring. It says "Ambiguous name detected: FormatCell"..

I'm confused with it..... any suggestions?

Please Login or Register  to view this content.

Thank you in advance for your help.

[shg]

Please take a few minutes to re-read the forum rules, and then start a new thread with an appropriate title.

Thanks.