Good day
This is a VBA-question
In a table, called "Table1" with four (4) headings and ten (10) rows (A1:D11) I would like to select the Table row of the active cell.
I.e. If I place my marker in A4 the row A4:D4 would be selected.
And no, the entire row can not be selected 
Best regards
Re: Select table row based on active cell
Not sure what the point is, but try this
ActiveSheet.ListObjects("Table1").ListRows(ActiveCell.Row - 1).Range.SelectThis is a helpful page for tables http://www.thespreadsheetguru.…o-listobject-excel-tables
Don’t have an account yet? Register yourself now and be a part of our community!