loop for cell value in a range

  • Hello
    I have a private sub which calls macro2 if any cell within row A2:to the end right changes its status to delivered. the problem is that even if I run macro2 separately it dose not work with no error. Appreciate any help

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim v As Range
     Set v = Sheets("process").Range("A2", Selection.End(xlToLeft))
        If v.Value = "7. Delivered" Then
        Call Macro2
        End If
    End Sub

  • It would be easier to help and test possible solutions if you could attach a copy of your file. De-sensitize the data if necessary. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!