Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple but very hard question
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple but very hard question
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple but very hard question
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
simple but very hard question
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question for you, but hard for me. | Excel Worksheet Functions | |||
Arrays Take too long. VERY HARD QUESTION. my head hurts : / | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple VBA question | Excel Discussion (Misc queries) | |||
Simple but hard | Excel Worksheet Functions |