Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am currently using Private Sub Workbook_SheetCalculate(ByVal Sh As Object) to execute code when the value of any cells (provided by external links) change. Is there any way to filter this so my code only runs if cells *within a particular range* change? Something like : if Sh.Range = within the range A1 to C10 then run the code else do nothing Seems a simple enough concept but I can't for the life of me figure it out! I have to use "calculate" events rather than "change" events as the cells are updated automatically, rather than by a user. Thanks, Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
do events? background events | Excel Programming | |||
events? | Excel Discussion (Misc queries) | |||
Workbook_SheetCalculate looping | Excel Programming | |||
Events | Excel Programming | |||
events | Excel Programming |