Yep, that does work out nicely. Thanks!

On Aug 28, 5:52 am, "Jim Rech" wrote:
Maybe you want something like this:

Sub a()
Dim MyList As ListObject
Dim RowNum As Long
Set MyList = ActiveCell.ListObject
RowNum = ActiveCell.Row - MyList.HeaderRowRange.Row
MsgBox RowNum
End Sub

--
Jim"Ferris" wrote in message

oups.com...
|I have a data table in xl2007 that is a ListObject. What I would like
| to be able to do is know which ListRow has been selected. In other
| words, if I manually select a cell in a ListObject is there a way to
| programatically know which ListRow that is? Banging my head for a bit
| trying to noodle it out, any help will be greatly appreciated.
|
| Thanks!