jl2509
Board Regular
- Joined
- Oct 30, 2015
- Messages
- 198
- Office Version
- 365
- Platform
- Windows
Hi All,
The problem I have is: There are many charts on a worksheet which are only visible when data is present
Each of the charts is setup in layout i.e. 1 chart per page, page breaks, print area etc.
However, when I print the charts, I get all the active charts and many blank pages?
Can anyone help with some VBA to select all charts on a worksheet and print them on a pdf.
The PDF should be 1 chart per page but a continuous PDF.
or
Is there a way to stop the blank ranges / pages being printed?
Thanks
The problem I have is: There are many charts on a worksheet which are only visible when data is present
Each of the charts is setup in layout i.e. 1 chart per page, page breaks, print area etc.
However, when I print the charts, I get all the active charts and many blank pages?
Can anyone help with some VBA to select all charts on a worksheet and print them on a pdf.
The PDF should be 1 chart per page but a continuous PDF.
or
Is there a way to stop the blank ranges / pages being printed?
Thanks