VBA Macro to print multiple sheets

[camerongreenfield]

Hi,

I am looking for a macro that goes through each worksheet (need to be able to specify worksheet name(s) in code as don't want to include every worksheet in macro) and prints each individual worksheet to pdf dependent on if a specified cell on the individual worksheet is greater than 0 (ignoring the formula in that cell).

When creating pdfs of each worksheet it will need to only print the cells which I have used in the worksheet and use the printer margins set. I also want to have the pdf document name reference text in 3 of the individual worksheet's cells.

Thanks