I am trying to have a msg box pop up when "Yes" is entered in range "G4:G10,G13:G17". However the code is not working, even when I list the range as one cell.
I did Debug ( no error), test ran the code & no response. Please let me know wat I am doing wrong.
Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Worksheets("October_Meeting_#_1").Range("G4:G10, G13:G17").Value = "Yes" Then MsgBox ("Please Enter the SC or NSC status, if this is the first meeting of the new Fiscal!") End If End Sub