Find statement help when it doesn't find anything

Hi, hockeyadc,

set a range to the cell if a value is found and check for the range like

If Wall.Value = True And AC.Value = True Then
     Sheets("Wall Mounts").Columns("C:C").Select
     Set rngFound = Sheets("Wall Mounts").Columns("C:C").Find(What:=Volts.Text, After:=ActiveCell, LookIn:=xlValues, LookAt _
        :=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
        False, SearchFormat:=False)
        
     If Not rngFound Is Nothing Then
        'your macro code when item is found

I woud avoid the use of ActiveCell in a macro if I can.

Ciao,
Holger