TTom
Well-known Member
- Joined
- Jan 19, 2005
- Messages
- 518
Is it possible to set cell active on designated worksheet, within designated range, if the result of its formula changes?
I've been looking at this problem from several angles, still with no success.
Example:
Sheet1, Range("A1:A100") has formulas where --
A1 formula: =Sheet2!A1
A2 formula: =Sheet2!A2
A3 formula: =Sheet3!A1
and so on...
If I change the value in Sheet3, Range("A1") I would want Sheet1, Range("A3") to become active;
this, because the calculated result of Sheet1, Range("A3") was changed when I entered a new value into Sheet3, Range("A1")
After cell is set active I'll need to call a proceedure. After it has run I'll need to set active the cell where I entered the change,
in this case reactivate Sheet3, Range("A1") and end sub.
I've been looking at this problem from several angles, still with no success.
Example:
Sheet1, Range("A1:A100") has formulas where --
A1 formula: =Sheet2!A1
A2 formula: =Sheet2!A2
A3 formula: =Sheet3!A1
and so on...
If I change the value in Sheet3, Range("A1") I would want Sheet1, Range("A3") to become active;
this, because the calculated result of Sheet1, Range("A3") was changed when I entered a new value into Sheet3, Range("A1")
After cell is set active I'll need to call a proceedure. After it has run I'll need to set active the cell where I entered the change,
in this case reactivate Sheet3, Range("A1") and end sub.