neodjandre
Well-known Member
- Joined
- Nov 29, 2006
- Messages
- 950
- Office Version
- 2019
- Platform
- Windows
I am trying to fire a macro only when the cell value inside a specified range changes (i.e. not selected but actually changed in value).
I am using this code but it fires every time a cell is selected.
I am using this code but it fires every time a cell is selected.
Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("mynames"), Range(Target.Address)) Is Nothing Then
x_admin.Range("operation") = Target.Range("A1").Value2
End If
End Sub