Ajryan, sorry to bother you again, but i am now trying to offset the column to the left. So basically if values of cells in column J is "Reset to Draft" then cells in column F will equal "Draft"
This is the current code i have but nothing is happening?
Private Sub Worksheet_Change2(ByVal Target As Range)
Dim rng As Range
Dim cell As Range
Set rng = Me.Range("J3:J400")
If Not rng Is Nothing Then
For Each cell In rng.Cells
If cell.Value = "Reset to Draft" Then
Application.EnableEvents = False
cell.Offset(0, -4).Value = "Draft"
Application.EnableEvents = True
End If
Next
End If
Set rng = Nothing
End Sub
Bookmarks