Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value at Intersecting cells
If you in fact want the MIDPOINT between the cells, name them Range1 and
Range2 and adapt the following for a code solution: Debug.Print Range("range1").Row, Range("range2").Row, _ Range("range1").Column, Range("range2").Column Debug.Print Range("range1").Offset( _ (Range("range2").Row - Range("range1").Row) \ 2, _ (Range("range2").Column - Range("range1").Column) \ 2) Note the integer division - you might be surprised when you see what happens with normal division by 2 there :) On Wed, 27 Aug 2003 08:46:12 -0400, "ibeetb" wrote: Is there a way to get the value of a cell which lies at the intersection of say......B8 and D8? (I'd prefer to do in code - but will accept doing it in a wrksht function) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Intersecting Names for lookup | Excel Discussion (Misc queries) | |||
Value at Intersecting cells | Excel Programming | |||
Value at Intersecting cells | Excel Programming | |||
Intersecting addresses from two sheets | Excel Programming | |||
Intersecting addresses from two sheets | Excel Programming |