VBA Code to PDF print with loop with specific count.

[mogheg]

Hello Friends,

I have 2 worksheets.

Sheet 1 has list of invoice details with invoice numbers in more than 2500+ rows.

Sheet 2 has Invoice Format. Based on Invoice numbers in cell no. 'T5', all Invoice details will be filled.

in Sheet 2, I wish to save each PDF print of these invoices separately with changes in invoice no. in cell 'T5' based on no. of rows in "Sheet 1" from cell 'B6'. Only positive invoice value in Cell 'T26' should be printed.

I have made below code for print

Sub Printpdf()
'
' Printpdf Macro
'
'
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\gmoghe\Documents\invoice\" & Range("T5").Value, Quality:= _
        xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
        OpenAfterPublish:=False


End Sub

 

[Takae]

What Err did you get? Which line is highlighted?

 

[mogheg]

Not any error showing while running code.