How do I reference tables in Excel using VBA?
The OP asked, is it possible to reference a table, not how to add a table. So the working equivalent of Sheets(“Sheet1”).Table(“A_Table”).Select would be this statement: Sheets(“Sheet1”).ListObjects(“A_Table”).Range.Select or to select parts (like only the data in the table): Dim LO As ListObject Set LO = Sheets(“Sheet1”).ListObjects(“A_Table”) LO.HeaderRowRange.Select ‘ Select just header row LO.DataBodyRange.Select ‘ Select … Read more