Create PDF files from multiple work sheets in a single work book

Dear All,

I have near about 50-150 work sheet in a excel file.

I need to create a individual pdf file through Macro.

Pdf file name will be sheet name.

My macro will be here, it works to convert in excel.

But i can not convert in PDF with Print Area Range("A1:C50")

Please help!

Please Login or Register  to view this content.