Please be sure to use [ CODE ] tags on future posts
Give this a shot. There is no need to export it to a new workbook first. You can just save/print the single sheet to a PDF file. The below will save the activesheet to a pdf file of your directory and file name of choice.
EDIT. I missed part of your post. But you can probably set the variabled pdfName to value in Cell F4 if you would like, hardcode the path to your sharepoint site possibly.
I'm not sure on the ability to save direct to sharepoint and if need any special permissions for that. Hopefully someone else can chime in on that.
Bookmarks