Select entire column in table using Excel VBA

by

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.

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Sequence of numbers based on start and end value of 2 cells [closed]
  3. Read/Parse text file line by line in VBA
  4. How do I find the last column with data?
  5. Excel VBA: Answer gets “stuck”
  6. How to insert a picture into Excel at a specified cell position with VBA
  7. Save multiple sheets to .pdf
  8. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  9. filter out multiple criteria using excel vba
  10. Excel VBA autofilter all but three
  11. How can I create a calendar input in VBA Excel?
  12. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  13. Using Google Chrome in Selenium VBA (Installation Steps)
  14. Excel VBA code to copy a specific string to clipboard
  15. Merge values of column B based on common values on column A
  16. How to import a table from web page (with “div class”) to excel?
  17. Range limit conundrum
  18. How do you run a .exe with parameters using vba’s shell()?
  19. Excel VBA – Range.Copy transpose paste
  20. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  21. How do you get a Range to return its Name?
  22. How to give a time delay of less than one second in excel vba?
  23. Changing the date format to yyyy-mm-dd
  24. Delete all duplicate rows Excel vba
  25. excel to pdf ignores print area and calls printer
  26. In Excel, can I use a hyperlink to run vba macro?
  27. Select Newest Record and Create New Table of Unique Values in Excel
  28. Are ActiveX Controls Disabled?
  29. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  30. VBA WinHTTP to download file from password proteced https website

Leave a Comment