I am wondering if anyone could please kindly help me
I need a VBA Macro to save each Excel sheet in a workbook as its own separate PDF based on the Value in a Cell (D9) on each sheet. I have the code to name by tab name but I can not work out how to save by cell reference.
The code I have to save by tab ref is as follows, I just need to alter it to used cell D9 as the saved Pdf file name
If anyone knows how to do this I would be so happy as its driving me nuts