Hello all,
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
Code
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
Display More
If anyone knows how to do this I would be so happy as its driving me nuts
Many Thanks
Debs