sarathmenon
New Member
- Joined
- Aug 18, 2021
- Messages
- 2
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hello All
I am new to VBA programming. I have an Excel workbook with two worksheets - one containing raw data and the other containing a pivot table and corresponding slicers for it.
My requirement is to use VBA to dynamically choose particular options in the slicers and copy the resultant pivot table into the body of an Outlook mail. The pivot table has a few hidden columns in between, so I would like to copy only the visible columns.
I found a solution online which helps me copy the pivot table if the slicer options are chosen manually. But the issue with that was that only the columns up till the first hidden column were chosen. So I wasn't able to copy the rest of the visible columns which came after.
Could someone please help me with this?
I am new to VBA programming. I have an Excel workbook with two worksheets - one containing raw data and the other containing a pivot table and corresponding slicers for it.
My requirement is to use VBA to dynamically choose particular options in the slicers and copy the resultant pivot table into the body of an Outlook mail. The pivot table has a few hidden columns in between, so I would like to copy only the visible columns.
I found a solution online which helps me copy the pivot table if the slicer options are chosen manually. But the issue with that was that only the columns up till the first hidden column were chosen. So I wasn't able to copy the rest of the visible columns which came after.
Could someone please help me with this?