Skip a range while saving excel data as PDF

Hello,

I've written a macro to save excel data as a PDF.
However, there are a couple of things which I'm not able to achieve.

Please Login or Register  to view this content.

1. How to save the file each time automatically with a different name? For e.g., it should be stored as 'Report_101_19Jul16', 'Report_102_19Jul16', and so on?
2. How to skip a particular range while creating the PDF out of the data? For e.g., it should create pdf of the data - "A1:C107 & H1:I107". Column D,E,F,G should be skipped out.
3. How to fit that content in a single page in the PDF generated? For e.g., currently, it is displaying column A, B in one page, others in a seperate page. How do I ensure all the desired content fits in one page?

Regards,
Anshul

This uses cell Z1 as a report number counter. Put 101 in Z11 and it willl be used in the file name and increased by 1 each time the macro is run. The macro generates a file name based on the Z1 number and the Date

Columns D:G are hidden before the sheet is saved as PDF and unhidden after the save.

Please Login or Register  to view this content.

Maybe try decreasing the font size on the sheet.