Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm trying to determine the location of a cell within a range. I know
that you can access cells in a range sequentially using range(_).cells(1), .cells(2), etc. What I'd like to be able to do is determine the 'i' for which range(_).cells(i) is the given cell. I can write a function easily enough to do this, but for economy I was just wondering if there was a trick I'd missed that would do it without. The range is contiguous, but not necessarily rectangular, so I can't simply multiple the row of the range that the cell is in by the column. Anyone know if such an inverse for .cells(i) exists? Thanks very much, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using cell's contents as an index to a row ...? | Excel Worksheet Functions | |||
Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
Using cell's contents as an index to a row ... ? | Excel Worksheet Functions | |||
how do i find and replace a portion of a cell's formula? | Excel Discussion (Misc queries) | |||
how to find last row/col index within a selected range | Excel Programming |