What I need it to do is look in a large range for and cell that equals "CR", then change the cell to the left of it to a negative and remove the "CR".
I have a code that I was working for a day. But now when I run the macro, it no longer does anything. Could it be a setting that I am overlooking, or is there a more reliable way to write this code?
Sub Negative_Convert()
For Each r In Range("A1:BA" & Cells(Rows.Count, "Y").End(xlUp).Row)
If r.Offset(0, 1).Value = "CR" Then
r.Value = r.Value * -1
End If
If r.Value < 0 Then
r.Offset(0, 1).Value = ""
End If
Next r
End Sub
Bookmarks