"Method or Data Member Not Found" Error on Loop. Please help review code.

Hi there,

I am trying to create a subfunction that mirrors conditional formatting.

Basically, if the cell value in A1 of the active sheet matches cell values of A1 in the previous sheet, I'd like it to be colored green.

I get a "Method or data member not found" error every time I try to run. This is my first time doing a loop. Please help me. (PS. There are ~350 rows and 27 columns on the active sheet)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

I assume you're attempting to target the same rCell position on other worksheets:

Please Login or Register  to view this content.