On change event for specific cells

[Guest]

I am familiar with the worksheet on change event, but can I use it to narrow
down so that the code runs only based on changes to a specific range of
cells, not knowing beforehand what the current value of any of those cells
are, only if the value in the cells in a specific range is changed? TIA

 

[Guest]

Two ways. The change event has an argument Target. That is the cell or cells
that were changed. So based on that...

if target.address = "$A$1" then
msgbox target.address
end if

'**or**

if not intersect(target, range("A1:B10")) is nothing then
msgbox target.address
end if

if the cell that you wnat to detect a chnge in is a formula then that gets a
bit trickier but it can still be done. Reply back if that is the case...

 

[Incidental]

hi there

a way to do it would be to use intersect

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("A1:A10")) Is Nothing Then

MsgBox "I am part of your set range"

Else

MsgBox "Where as i am not"

End If

End Sub

hope it helps

S