Guest User

Untitled

a guest
May 22nd, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. Sub Test()
  2. Dim the_sheet As Worksheet
  3. Dim table_list_object As ListObject
  4. Dim table_object_row As ListRow
  5.  
  6. Set the_sheet = Sheets("Base de datos")
  7.  
  8.  
  9. Set table_list_object = Sheets("Base de datos").ListObjects("table1")
  10.  
  11.  
  12. Set table_object_row = table_list_object.ListRows.Add
  13.  
  14.  
  15. last_row_with_data = the_sheet.Range("A65536").End(xlUp).Row
  16.  
  17. the_sheet.Range("A" & last_row_with_data) = ActiveSheet.Range("B9:B20")
  18.  
  19. the_sheet.Range("B" & last_row_with_data) = ActiveSheet.Range("C9:C20")
  20.  
  21. ' the_sheet.Range("C" & last_row_with_data) = ActiveSheet.Range("L2")
  22.  
  23. ' the_sheet.Range("D" & last_row_with_data) = ActiveSheet.Range("L3")
  24.  
  25.  
  26.  
  27. End Sub
Add Comment
Please, Sign In to add comment