Hi,

I am aware of how to save a number of excel sheets to one single PDF, but what I want to be able to do is save 30 excel sheets that are within the same workbook, into 30 individual pdf's in a particular location.

Any ideas on a macro to do this?

Any help would be greatly appreciated as at the moment I am spending far too much time doing one by one!

Thanks,
Keith