I have a table "TableEx" in a Sheet of my Excel File. I have created a ListObject loTable and I have set it as follow:
'Define Variable
sTableName = "TableEx"
'Define WorkSheet object
Set oSheetName = Sheets("BBDD Ventas")
'Define Table Object
Set loTable = oSheetName.ListObjects(sTableName)
The thing is that im trying to use some functions of tables (for example .removeDuplicates) but I dont want that this actions could have effect in my real table (the one in the sheet). When I run this line :
loTable.DataBodyRange.RemoveDuplicates
it remove the duplicates of my original table. How can I do it?