Radoslaw Poprawski
Active Member
- Joined
- Jun 19, 2021
- Messages
- 398
- Office Version
- 365
- Platform
- Windows
Hello,
I visited sites like VBA Tables and ListObjects - Excel Off The Grid
and The VBA Guide To ListObject Excel Tables — TheSpreadsheetGuru
and I cant find what Im looking for,.
My problem:
How Do I select Header and data.body.Range simultaneously ?
I tried:
but it does not work.
My table has Header, DataBodyRange and totals row.
I need to select all exept total row which needs to stay.
I visited sites like VBA Tables and ListObjects - Excel Off The Grid
and The VBA Guide To ListObject Excel Tables — TheSpreadsheetGuru
and I cant find what Im looking for,.
My problem:
How Do I select Header and data.body.Range simultaneously ?
I tried:
VBA Code:
Range("PTTUC___DTO_Reversal[[#Headers],Data.Body.Range]").Select
but it does not work.
My table has Header, DataBodyRange and totals row.
I need to select all exept total row which needs to stay.