I'm trying to create a VBA code that I can use for multiple workbooks. Ultimately, I'm running a series of calculations and then in the end I'm PDF'ing the workbook and saving it. I'd like to be able to save the workbook using the same name as a cell within the workbook. Obviously the name of the cell varies from workbook to workbook and that's why I'd like to write in a code that will use a cell reference as the name rather than having to manually update the code for each PDF.