My format recently changed resulting in all kinds of fun figuring out how to readjust my macros. This macro will look at A2, then look through the worksheets and find the matching sheet and save that sheet as a PDF with the filename. However, A2 will always just save the activesheet that has the list of all filenames. I've attached a workbook. The "Notes" sheet has three filenames. If you run this code then it should take the # out of the filename, match it to a sheet and export it. Instead, whatever is in A2 will save the "Notes" sheet as that filename. So A2 never is saved correctly. How do I exclude that sheet?
Bookmarks