Run macro when any cell in a certain range is changed

[alyssa75]

How can I have a macro run when any cell in Range("MyRange") is changed?

Thanks!

 

[brian.wethington]

Here is some event code

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range

Set Rng = Intersect(Target, Range("MyRange"))
If Rng Is Nothing Then Exit Sub
'perform steps you wish the macro to perform here

End Sub

Right click the tab you want this to run on and select view code. Paste code there. HTH!