example from Help:

Worksheets("Sheet1").Activate
Set isect = Application.Intersect(Range("rg1"), Range("rg2"))
If isect Is Nothing Then
MsgBox "Ranges do not intersect"
Else
isect.Select
End If




"Chief Wiggums"
wrote in message
news:Chief.Wiggums.23sqla_1140889801.4844@excelfor um-nospam.com...

I can use OnEntry to trigger a macro when any cell on a given sheet is
edited --

Sub Auto_Open()
Worksheets("Sheet1").OnEntry = "TriggeredMacro"
End Sub

Is there a way to limit the triggering to just certain cells? so that
only editing in those cells initiates the macro?

Thanks in advance ...


--
Chief Wiggums
------------------------------------------------------------------------
Chief Wiggums's Profile:
http://www.excelforum.com/member.php...o&userid=16934
View this thread: http://www.excelforum.com/showthread...hreadid=516531