Export specific sheets to individual PDFs and rename each one adding an incremential no

So, I have the following macro and function to increment the title by one, which obviously doesn't work. I am try to send specific worksheets to pdf based on name, and rename it with an incremetial number.I'm guessing that I should loop it, but no idea on how to.
It creates the pdf file with the naming, butsince it does't increment the file with the bigest number, it just gets replaced everytime, so instead of having 3 files: No.3,No.5,No.7, I have a No02 file and that's it. Also, it should increment it by 2
Maybe anyone has a good ideea on how to get the desired result?

Thanks

Please Login or Register  to view this content.

Please upload a sample file to make use of....

Please find attached. Also, I already have a file named No.1 in the folder

So as I understand it...

You want to create a Folder called AIR12 and save specific sheets to this folder named No02, No05, No07 ???

Please Login or Register  to view this content.

So easy and so simple, sintek. Thank you very much

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Thanks.gif