Hi
Im trying to select the entire row in a table with the mouse click but im stuck.
Im trying to select the entire row in a table with the mouse click but im stuck.
VBA Code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.ListObjects("TabelOversigt").ListRows(?????).Range.Select
End Sub
I have tried the Target.Address, but i think its only allowed to reference a cell.
I need the "ListRows()" to be filled with the rownumber im clicking in the table
Thanks