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