How to select all items from table excluding headers?

Question

With this line you select all cells of table1, including headers:

ActiveSheet.ListObjects("Table1").Range.Select

I need to select all objects save for the headers.

Answer 1

1. You normally don't need to Select.
2. The DataBodyRange "represents the range of values, excluding the header row, in a table."

Use ActiveSheet.ListObjects("Table1").DataBodyRange.