Hi there all
I have a merged cell = P5 to U5
I have written the following vba to call a macro if this cell changes but to no success
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "p5" Then
Call ADVDAY1
End If
End Sub
Pls assist to enable me to learn what I have done wrong