각각의 sheet를 sheet 이름으로 한 pdf 생성
Sub PdfCreate() Dim ws As Worksheet Dim Fname As String For Each ws In ActiveWorkbook.Worksheets On Error Resume Next 'Continue if an error results ' Name generated PDF files based on the worksheet Index (i.e. 1,2,3, etc.) ' Fname = "Annex 1.1." & ws.Index & "_result" ' Another option is to use the worksheet name. This may cause errors if the worksheet ' name contains characte..