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
Option Explicit Sub SaveWorksheetAsPDF() Dim ws As Worksheet For Each ws In Worksheets ws.ExportAsFixedFormat xlTypePDF, "C:\Users\lucy\Dropbox\certs" & ws.Name & ".PDF" Next ws End Sub
If anyone knows how to do this I would be so happy as its driving me nuts