How to find a cell's location/index within a range?
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
|