Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) | Excel Discussion (Misc queries) | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
How find if target is object in Worksheet_Change (ByVal Target As.. ?) | Excel Programming | |||
Error with Target.Name.Name in Worksheet_Change event | Excel Programming | |||
Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet | Excel Programming |