Value of first column in active row in ListObject

[Stevenn]

I want the value of the first column in the active row in a ListObject.

I've tried

MsgBox ActiveCell.ListObject.ListRows(ActiveCell.Row).Range.Address

, but don't know how to refer to the first column in this row. I've also tried

MsgBox ActiveCell.ListObject.ListRows(ActiveCell.Row).ListColumns(1).Range.Value

, but it returns an error message.

 

[Firefly2012]

I would think this would work:

MsgBox ActiveCell.ListObject.ListRows(ActiveCell.Row).Range.Columns(1).Value

There may well be easier ways to do it though

 

[Stevenn]

It doesn't refer to the right row when I use your code.

 

[Firefly2012]

What does

MsgBox Activecell.ListObject.Range.Address

return? Possibly it is not returning what you want because your listobject does not start in row 1? Then:

With ActiveCell.ListObject
  MsgBox .ListRows(ActiveCell.Row - .Range.Row + 1).Range.Columns(1).Value
End With