Export to PDF via code

[jrisebo]

So I have this code

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\test" & x & ".pdf"

It loops thru and creates a PDF as long as "x" has some text. But it creates 1 seperate per file
Anyway to have it loop thru and create the PDF all in one file?

 

[JEC]

Are you printing the same page over and over(single page print area)? Or are you printing multiple pages?

 

[jolivanes]

Further to JEC
Re" as long as "x" has some text"
Maybe explain what that means.