Maybe I should be more clear. What I am looking for instead of

Formula: copy to clipboard
Set rngFindTotal = .Cells.Find("Zirh", LookIn:=xlValues, lookat:=xlPart, MatchCase:=False)

is
Formula: copy to clipboard
Set rngFindTotal = .Cells.Find([Range D2:D20 on worksheet "Config"], LookIn:=xlValues, lookat:=xlPart, MatchCase:=False)


Or the equivalent of that. I'm not trying to remove rows from Range D2:D20, I'm USING that range to remove rows from a whole other Worksheet ("Config")