Big Help Needed: Search for Value w/ Code- Cell is formula

[DougStroud]

Here is a simple loop that I want to find any values w/ a dash in them.
The issue is the cells are still in Formula and I cannot make them values first. So I need to find a way of searching in the cell for this value while it remains as a formula. Possible I hope.

This works as long as the cell values are values, but fails if formula.

For i = 4 To 6 'LRowf
If Cells(i, "M").Text Like "*-" Then
Cells(i, "M").Interior.Color = vbYellow
End If
Next i

 

[jindon]

Hi

it sounds like

If Right(Cells(i, "M").Value, 1) = "-" Then

 

[DougStroud]

J-
What about If InStr, could that work?
The value could be 1 or 2 from left or right, e.g., 7-8, 9-10, 10-11 something like that.
I will do some research....

 

[jindon]

In that case

InStr

If InStr(Cells(k, "M").Value, "-") > 0

or
Like operator

If Cells(i, "M").Value Like "*-*"

 

[DougStroud]

Fantastic- Thanks Jindon!

 

[DougStroud]

Jindon,
I don't know how you have any time to do your own work--- you are always helping us