Return true to a cell if a range has been altered

[Rejje]

Hi!
I'm need a specific cell to show "True" if a one has done some altering of values in a range.

How is it done?

[Bob Phillips]

You could use a worksheet event, something like



Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "H1:H5" '<<<< change to suit

On Error GoTo ws_exit

Application.EnableEvents = False

If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then

'do stuff ... and then

Me.Range("M1").Value = True
End If

ws_exit:
Application.EnableEvents = True
End Sub