I'm trying to find repeated text in a particular column ("A2:A21") by using "Find" Method. At '.Find' code, iam getting "Type Mismatch" error. Pls go through the below code and help me.
Dim l As Variant
Dim rng, rfound As Range