Rin macro on worksheet change only if column changed

[sharky12345]

Is there a way I can run a macro on a worksheet_change event but only if the cells that have been changed are in the range A4:A23?

 

[Fluff]

Something like this

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Range("A4:A23")) Is Nothing Then Call Macro1

End Sub

 

[sharky12345]

Thanks Fluff - works a treat!

 

[Fluff]

Glad to help & thanks for the feedback