All you have to do is put in the link cell =C4. You can manuals do theis on
the worksheet or do it by VBA

Range("A1") = "=C4"

or

Range("A1").formula = "=C4"

I don't see any difference with C Language, Basic, or Assembly Language. I
have over 25 years of writing code in all three languagges plus Fortran and
Pascal. I have writen assembly language proably in 10 diffferent assembly
languages.

"Mac" wrote:

I need cells linked together based on their values.
I've made up the following scenario:
select a cell (e.g. C4); invoke a macro which decremets the value in C4 by
one; another cell (e.g. A2) is somehow 'linked' to C4 and so is decremented
by one as well; that's it.
My requests a
1. Could someone please hint me to the code to do this (I'm thinking in C
and assembly, which is unfortunate for this task of course)
2. I'll have more of such links throughout my worksheet, so the perfect
solution would be to store each cell's link to its 'custom property' so that
the macro code would only read the cell clicked and from its properties see
what other cells should be afected; hope I'm making myself clear... Is this
possible somehow?