I have a macro which when run, will go through a dropdown list and print the spreadsheet for each one. However I would like to print a separate sheet to pdf
So I have a couple of questions, they are relatively simple I think.
1) I want to save each page of the list as a pdf, can I reference a cell as a file name? I think I put in a line of code which says ' Set Filename="H1", but then I am not sure how to reference this later on.
2) how do I reference a different 'ActiveSheet', i.e. the page to printout is not the one with the list on.
Bookmarks