How to save a worksheet as pdf into a SharePoint list and include the metadata at the same time

I have written vba that saves the current worksheet in excel as a pdf to a SharePoint document list. I would like to save the metadata for the list at the same time. The metadata exists in named cells in the excel worksheet.

This is the vb code I am using to save the pdf of the worksheet to SharePoint. I just want to include the metadata properties too.

'Create the PDF and save into the SharePoint List

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _

    FileName:=MySharePointPath & MyFileName, _

    Quality:=xlQualityStandard, _

    IncludeDocProperties:=True, _

    IgnorePrintAreas:=False, _

    OpenAfterPublish:=False