Run macro if any cell in a named range changes

[Ken Russell]

I'm tearing my hair out trying to get this to work.

I have a range named Text in a sheet in a workbook. I would like the macro FillComments to run when any cell in that range is changed.

I can't see why the following doesn't work

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target.Addresss = Range("Text")) Is Nothing Then Exit Sub
Application.EnableEvents = False
Call FillComments
Application.EnableEvents = True
End Sub

Any help would be appreciated by this 81 year old

Cheers,
Ken

 

[VoG]

Hurrah!

 

[Ken Russell]

Interestingly, it also works if I change the named ranges from Dave1 to Text and from Dave2 to Comments.

It was your patience that made me keep experimenting - thank you for your help.

Cheers,
Ken