VBA生成的pdf名称可以对应于某些单元格中的值吗？

Sub GeneratePDF()
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range
    Dim pdfName As String
    
    Set ws = ThisWorkbook.Worksheets("Sheet1") '替换为你的工作表名称
    Set rng = ws.Range("A1:A10") '替换为你想要获取值的单元格范围
    
    '构建PDF名称
    For Each cell In rng
        pdfName = pdfName & "_" & cell.Value
    Next cell
    
    '生成PDF
    ws.ExportAsFixedFormat Type:=xlTypePDF, Filename:=pdfName & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False
End Sub