Question : vba if value exists in range
Answered by : boomslang-frikkie
If Not IsError(Application.Match(ValueToSearchFor, RangeToSearchIn, 0)) Then ' String is in range
Source : https://stackoverflow.com/questions/12642164/check-if-value-exists-in-column-in-vba | Last Update : Wed, 13 Oct 21