VBA select the entire Table row below ActiveCell

[kaseyleigh]

Hi

I have code to Add a row to my Table ...

Selection.ListObject.ListRows.Add (ActiveCell.Row)

Now, how do I select the entire Table row below ActiveCell?

Your help very much appreciated.

Thanks!

[romperstomper]

To select the new row:

    Selection.ListObject.ListRows.Add(ActiveCell.Row).Range.Select

[kaseyleigh]

Awesome! thank you Rory

[romperstomper]

Glad to help.

Don't forget to mark the thread solved, please.