Need code for print and export for the dyanamic range selection if extended the data range

Hi All,

Greetings!!

I created an excel report (added a conclusion under some analysis header) in which I want to add a print and export button. I also created a userform for the export button, but I'm not sure what the exact vba coding for the dynamic selection range according to the field shown will be, or if the field is extended by the existing VBA coding execution, the print or export selection range will be extended. If the analysis is not fit on any page when printed or exported, it will appear on the following page. This implies that if the whole conclusion with analysis header is not fit on any page, a page break will be applied from that analysis header as per the sample pdf format.

Can a VBA expert help me on this? I'll be eternally thankful to him.

Hi Experts,

Can someone help me in this post?

Can a true VBA expert support me on this?

Originally Posted by Marc L

Hi,

what is your definition of « a true VBA expert » ?!

Hello, Marc. Thank you for your response. I mean, can anyone understand what I'm attempting to achieve, and if any vba specialist understands and can help me with the post?

Thank you ByteMarks for responding with the VBA code I needed. Yes, it works, however the content is very small and difficult to see even at 141% usual zoom in the exported pdf file. Can we increase the font size and extend the margins on both sides to make it easier to read? Also, I'd want to ask whether we can print with this coding  or can this be exported into a word document also?

Hello, ByteMarks!

Thank you for updating the code. I tested it to its runs in my existing file. It is functional for all three features. Print, then export to "PDF" and "DOC" formats. However, the fonts in my exported PDF file are not readable since we have to zoom in to view it. I'm attaching both pdfs. The first is the one I attached to my post, and the second is the exported pdf of your coding. Is it conceivable that the analysis for PDF will not autofit because the analysis header will extend, causing the pdf content to shrink?

Can we fix the font size and margin such that the viewable material automatically extends to the next page, but with a page break if any analysis splits into two pages? Similarly, it will work for the print and doc export functionalities as well.