Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub Test()
- Dim the_sheet As Worksheet
- Dim table_list_object As ListObject
- Dim table_object_row As ListRow
- Set the_sheet = Sheets("Base de datos")
- Set table_list_object = Sheets("Base de datos").ListObjects("table1")
- Set table_object_row = table_list_object.ListRows.Add
- last_row_with_data = the_sheet.Range("A65536").End(xlUp).Row
- the_sheet.Range("A" & last_row_with_data) = ActiveSheet.Range("B9:B20")
- the_sheet.Range("B" & last_row_with_data) = ActiveSheet.Range("C9:C20")
- ' the_sheet.Range("C" & last_row_with_data) = ActiveSheet.Range("L2")
- ' the_sheet.Range("D" & last_row_with_data) = ActiveSheet.Range("L3")
- End Sub
Add Comment
Please, Sign In to add comment