D
dhockin
XL 2003
Would like to return the address of a formula to a cell, need some
combination of Indirect and Cell (address) I think,
Example
A1 100 ( a value)
A2 = a1
A3 want to return cell addresss that formula in A2 is pointing to (ie
A1) =cell("address",a2......here's where I need the help
It would be complex if A2 had mulitple pointers, but in my case they
are just 1 cell
Would like to return the address of a formula to a cell, need some
combination of Indirect and Cell (address) I think,
Example
A1 100 ( a value)
A2 = a1
A3 want to return cell addresss that formula in A2 is pointing to (ie
A1) =cell("address",a2......here's where I need the help
It would be complex if A2 had mulitple pointers, but in my case they
are just 1 cell