Don't know if I follow exactly what you're looking for.

XL has an "intersection" operator, which is simply a <Space.

So, if C5 contained, say 100, then:

=5:5 C:C

Would return 100.


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Wu" wrote in message
...
I want to move to a cell according to junction of two cells.

e.g

I have data at RANGE("A5"), RANGE("C1"),
I want to move to the junction ---RANGE("C5")

1. How can I get the RANGE of the cell?
2. How can I move to the junction of two cells?