Copy a table hidden & visible row data & paste all data

[How How]

Hi,
Part of my code is below which works if there are no hidden columns...... I would like to change this code to:-

1. Copy visible & hidden data in a row (Some hidden columns).
2. Limit copy / paste to table row (not whole row on sheet).
3. Change part of code to refer to table name & table columns.

EG Table name = "Sub9" & Col "B" = "Sub SN"

Thinking about it...... Is there a code that selects all row data using table header names?

lCol = Cells(Target.Row, Columns.Count).End(xlToLeft).Column
    Range(Cells(Target.Row, 2), Cells(Target.Row, lCol)).Copy
    Sheets("Completed Log").Range("B" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial Paste:=xlPasteValues

If someone could help with this I would change all my code for "tables"

P.s Using excel 2010 - 2016

Thanks

[How How]

Example attached