Part of the reason it's "hard" is because all the information isn't available.

1. Do you want to do this with VBA or with a formula?
2. What is being copied?
3. How do you determine which row and which column are used to determine
the intersection? There are intersecting points at A1 and C5. Do you want
the largest row and column or the smallest row and column?

Barb Reinhardt



"Wu" wrote:

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?