Hi,
I've got a workbook that runs through a series of filters, generates new sheets, and prints their contents to PDF files.
I'm currently hard-coding a print range, "A1:J40", for the exported PDF files.
However, what I would really like to be able to do is to have the range dynamically change based on the last row of available data.
The reason for setting it to end at J40 is because that's the largest dataset I have encountered thus far, but that may likely change.
I've attached a sample of my code below that generates the PDfs (with range selection in bold) as well as the actual workbook that I'm using to generate all of these PDFs.
I would genuinely appreciate any help offered.
Thanks in advance!
Please Login or Register to view this content.
Bookmarks