insaider16
New Member
- Joined
- Nov 15, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Greetings masters. I have a question, I have a table and using a macro, I add an empty line at the bottom of the button. How to implement the code for the button + three lines at the end of the table.
Code for one line
Code for one line
VBA Code:
Sub Test()
Dim the_sheet As Worksheet
Dim table_list_object As ListObject
Dim table_object_row As ListRow
Set the_sheet = Sheets("Lilu1")
Set table_list_object = the_sheet.ListObjects("Nom")
Set table_object_row = table_list_object.ListRows.Add
End Sub