Forum Discussion

Christof_20's avatar
Christof_20
Copper Contributor
Oct 13, 2020

Get all references from other cells to a specific cell

Hello everybody,   i am working on a makro to change column height for merged cells - This works good so far. But now i do have another cell, that has a reference for the same content (same file, ...
excel
Macros and VBA
Christof_20's avatar
Christof_20
Copper Contributor
Nov 12, 2020

So, one last try: does any developer has an answer?

How does Sheet#1 know if some value in Sheet#2 has changed?

 

Thank you in advance.

  • mtarler's avatar
    mtarler
    Silver Contributor
    Nov 12, 2020

    Christof_20  In VBA you a Range object has the following properties:

    .Dependents

    .Precedents

    .DirectDependents

    .DirectPrecedents

    I think those properties should help you with your challenge.

    I see your actual question is how sheet1 knows a value on sheet2 changed but you need to think it in reverse and say when value on sheet2 changes (OnChange event) then it checks its Dependents.

     

    [[EDIT]] I just checked on these properties and they don't seem to be giving me the address(es) for corresponding cells on other sheets.  I'm not sure why and if I'm making a mistake but I see it giving the precedents and dependents from the same sheet but not a different sheet.  hopefully I'm just missing something.

Resources