Each Page save as PDF

Hi.

Could Any one give me a solution with VBA Code.

My worksheet Sheet1 has 20 pages of Data and I want every Page to be saved as PDF in destination folder ( "C:\Documents\")

Desired Result : Save
page 1 of 1 as P1.pdf
page 2 of 2 as p2.pdf
page 3 of 3 as p3.pdf
-
-
-
-
page 20 of 20 as p20.pdf


Million thanks in advance

Regards

https://www.excelforum.com/excel-pro...idual-pdf.html

Please Login or Register  to view this content.

Please Login or Register  to view this content.

WOW, Thank you so much Both Methods worked to me..

Thank you ALL, you guys made my day

One query is Pending, Can we also save as JPG each Page.



Regards

Like variant:

Please Login or Register  to view this content.

Hi , I am looking for JPG Format not pdf.

If all the rows are the same height, this would be the easiest I think.

Please Login or Register  to view this content.