| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning the position of the Cellpointer in the range
Hi,
The Table below is called Tbl_AgeProfile. I'd like to be able to return the row and column offset of the Cellpointer from R1. EG if the Cellpointer is highlighting the cell with the value 91, i want to return 5,4 where 5 is the row down and 4 is the column across. Any ideas please? Thanks John R1 R2 R3 R4 R5 R6 2 20 418 590 135 29 0 11 74 189 68 3 2 8 51 95 85 3 1 11 53 91 27 4 2 14 16 75 14 1 0 16 14 135 31 1 1 5 0 0 0 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cellpointer | Excel Discussion (Misc queries) | |||
| Getting a position XY (range) on a matrix | Excel Discussion (Misc queries) | |||
| Find the POSITION IN A RANGE of text in a string that matches value(s) in a range | Excel Programming | |||
| Returning Position Points from the currently selected cell | Excel Programming | |||
| Returning MAX value and MATCH position in specific cells | Excel Programming | |||
Threaded Mode
