Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autorun a macro on change of cell value (having formula)
I need to run a macro on change of values in a range having forumlas in
various cells. The below logic doesn't work unless the cursor is in the given rangevalue If Not Intersect(Target, Range("rangevalue")) Is Nothing Then MsgBox "Cell has changed" End If Since my cells are having formulas, they change automatically with change in other ref. cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Macro To Change Cell Color (Continued) | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |