My question is what code to write to select the last 10 lines with data from the table (image)enter image description here.So that, of course, each time a row is added, it selects a different range. I have been trying this code:
Dim tblBAZA As ListObject
Set tblBAZA = Sheets("BAZA").ListObjects("BAZA")
LR = tblBAZA.ListColumns(1).Range.Rows.Count
LC = tblBAZA.ListRows(1).Range.Columns.Count
tblBAZA.Resize(LR, LC).Select
Set Getrange = tblBAZA.Range(LR, 1)
and i have this errorenter image description here
I don’t know the VBA well, so I have a problem with tables. I think the question is simple to solve but i don’t know what just write
New contributor
Pabtan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.