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

--
Gary''s Student - gsnu200752


"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?