Worksheet_change Target Address is Reference Cell
 

Hi
I am using the following code for triggering a macro on cell valu
change.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$F$1" Then
Call MyMacro
End If
End Sub

This works fine if I change the cell value of F1 directly, but does no
when F1 is linked to another cell, where I make the change. For example
target cell F1 has a formula of "=E1", when I change the value of E1
the macro does not trigger. Even when I assign a Range Name for th
Target cell, this fails to work.
Is there any way out for this ? I appreciate help in this regard

Redd

--
mpredd
-----------------------------------------------------------------------
mpreddy's Profile: http://www.excelforum.com/member.php...fo&userid=1327
View this thread: http://www.excelforum.com/showthread.php?threadid=26452