| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Tables - Get Active Cell Row and Column
Does anyone know a quick way to get the relative position (row and
column) of the selected cell within a table? I've tried a few different items, but to no avail: tmpRow = Selection.ListObject.Listrow tmpRow = Selection.ListObject.ListRows.Index tmpRow = Selection.ListObject.Range.Row and others ... I know it's got to be simple, but any help would be appreciated. Thanks in advance, TB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selection of cell at the intersection of column B and the row ofwhatever cell is active | Excel Programming | |||
| API to find position of active cell no longer working in 2007. | Excel Programming | |||
| Why doesn't active cell move using PageDown key in Excel 2007? | Excel Discussion (Misc queries) | |||
| Display of Active Cell in MS Excel 2007 | Excel Discussion (Misc queries) | |||
| copying the column of the active cell to another column | Excel Programming | |||
Threaded Mode
