Maybe I should be more clear. What I am looking for instead of
Formula:
Set rngFindTotal = .Cells.Find("Zirh", LookIn:=xlValues, lookat:=xlPart, MatchCase:=False)
is
Formula:
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")
Bookmarks