Hi,
I've got bunch of code that I want to run when a specific cell is changed so the Sub starts:
Can anybody think why this wouldn't just catch changes in the cell D6?
For me the rest of the code runs if any cell on the sheet is changed.
I've got bunch of code that I want to run when a specific cell is changed so the Sub starts:
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Target.Worksheet.Range("D6")) Is Nothing Then
'run rest of code...
Can anybody think why this wouldn't just catch changes in the cell D6?
For me the rest of the code runs if any cell on the sheet is changed.