Excel 2007 Tables - Get Active Cell Row and Column

  • Thread starter Thread starter TW Bake
  • Start date Start date
T

TW Bake

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
 
I don't have access to v2007 just now, but something like

rowOffset = ActiveCell.Row - ActiveSheet.ListObjects(1).Row
colOffset = ActiveCell.Column - ActiveSheet.ListObjects(1).Column
 
Back
Top