I have a bit of code that works fine, for finding any error cells. What I am trying to do is to have a similar bit of code, but instead of finding the '#N/A' cells, I want it to find any cells in the range which are not zero.
Code
Sub FindNA()
With Worksheets("Phasing").Range("V6:AC15000")
Set c = .Find("#N/A", LookIn:=xlValues)
If Not c Is Nothing Then
MsgBox "Error in cell" & c.Address, vbCritical, "Project Lookup Error"
Else: MsgBox "There are no error cells - you may continue", vbOKOnly, "Project Lookups"
End If
End With
End Sub