Hi Guys,

I'm really stuck here trying to figure this out.

I have a column of data that may or may not have a formula in them. The cells are formatted in Accounting, w/o the leading $ sign. (i.e. 133.57) The value zero shows up as a hyphen or dash.

The issue is that when I'm trying to write a macro that highlights all values that are zero (hyphen), the find code can't find it. I'm clueless on what to do.

Please help. Below is a strip down version of the code. Thanks!


Dim foundcell as range
Dim rLookIn as range

Set rLookIn = range("A10:A380")

set foundcell = rLookIn.Find(what:=0,lookin:=xlvalues,lookat:=xlwhole)
foundcell brings up nothing, even if there's zeros in the column.