Select a dynamic table range on a cheet with 2 tables

[mabelO]

Hi,

I have a spreadsheet with 2 tables being populated unto it.

Table_1 populates first and table_2 starts directly 2 cells after Table_1 ends.

I know that table 1 always starts from range A5. I want to be able to tell where table 1 ends and select the whole range of Table_1 and copy to clipboard.

I have attached a mini visual of what i mean.

 

[My Aswer Is This]

To populate a Table on the Active sheet Table named "Charlie"
Use a simple script like this:

Sub Populate_Table()
'Modified  4/30/2021  1:24:29 PM  EDT
Application.ScreenUpdating = False
    With ActiveSheet.ListObjects("Charlie").DataBodyRange
        .Cells(1, 1).Value = "Hello"
        .Cells(1, 2).Value = "Bob"
        .Cells(2, 1).Value = "Hello"
        .Cells(2, 2).Value = "Sam"
    End With
    Application.ScreenUpdating = True
End Sub