simple but very hard question

[Guest]

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?

 

[Guest]

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

 

[Guest]

Not difficult if you want to move the to lower right-hand corner of the range:

Sub wu()
Set r1 = Range("A5")
Set r2 = Range("C1")
rrow = Application.WorksheetFunction.Max(r1.Row, r2.Row)
ccol = Application.WorksheetFunction.Max(r1.Column, r2.Column)
Application.Goto reference:=Cells(rrow, ccol)
End Sub

 

[RagDyeR]

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!
=====================================================

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?