DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
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.
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.
Code:
For i = 4 To 6 'LRowf
If Cells(i, "M").Text Like "*-" Then
Cells(i, "M").Interior.Color = vbYellow
End If
Next i