I have been trying to figure out how to get worksheet to run macro when only certain cells change.
Do I have to create a worksheet change for each cell or can it be written in to one worksheet change
For example, I want macro to run if HA5 = 1, as well as every other +1000 row of column (HA1005, HA2005, ect)
Do I have to create a worksheet change for each cell or can it be written in to one worksheet change
For example, I want macro to run if HA5 = 1, as well as every other +1000 row of column (HA1005, HA2005, ect)
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim MainCells As Range
Set MainCells = Range("HA5")
If Not Application.Intersect(MainCells, Range(Target.Address)) _
Is Nothing Then
Select Case Target.Value
Case "1"
Call Macro2
End Select
End If
End Sub