I am trying to have one master Worksheet change macro that will call the other macros. If anywhere in column A there is a value "Unknown Region" it should trigger Macro1. Macro1 should insert a row and highlight cells C through F. Once when made entries it should change to a different color. Is this possible to do?
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A2")) Is Nothing Then
Select Case Range("A2")
Case "Unknown Region": Macro1
End Select
End If
End Sub
Sub Macro1()
Dim LastRow As Long
Dim i As Integer
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To LastRow
If Cells(i, "A").Value = "Unknown Region" Then
Rows.Insert Shift:=xlShiftDown
End If
End Sub