With these codes you can select different parts of a table.
Entire Table:
ActiveSheet.ListObjects("Table1").Range.Select
Table Header Row:
ActiveSheet.ListObjects("Table1").HeaderRowRange.Select
Table Data:
ActiveSheet.ListObjects("Table1").DataBodyRange.Select
Third Column:
ActiveSheet.ListObjects("Table1").ListColumns(3).Range.Select
Third Column (Data Only):
ActiveSheet.ListObjects("Table1").ListColumns(3).DataBodyRange.Select
Select Row 4 of Table Data:
ActiveSheet.ListObjects("Table1").ListRows(4).Range.Select
Select 3rd Heading:
ActiveSheet.ListObjects("Table1").HeaderRowRange(3).Select
Select Data point in Row 3, Column 2:
ActiveSheet.ListObjects("Table1").DataBodyRange(3, 2).Select
Subtotals:
ActiveSheet.ListObjects("Table1").TotalsRowRange.Select
For a full guide on tables see The VBA Guide To ListObject Excel Tables.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…