data table - scope to sheet ??

[zico8]

Hi

I have excel workbook with one sheet named “my_sheet_1”. There is data table named “my_table” inside this sheet.


I use this table in VBA referring by “vba_table_1”:

Please Login or Register  to view this content.

I would like to copy and paste this sheet inwardly my one workbook using VBA and referring table by “vba_table_2”.


I can copy sheet and set it name to “my_sheet_2” but cannot set “vba_table_2”, because “my_table” name is being changed after sheet copy and I do not know what table name will be after it:

Please Login or Register  to view this content.

The best way would be to set table scope to worksheet instead of workbook but is there any way to do it??

[Bernie Deitrick]

Please Login or Register  to view this content.

[zico8]

Thx

But if I have mire then one table in my_sheet ?

[Bernie Deitrick]

The newest one will have the highest index, which will be - ThisWorkbook.Sheets(“my_sheet_2”).ListObjects.Count - which is why my code will pick out the table just added to the sheet.