Macro to create a PDF of every sheet in a range?

[tonywatsonhelp]

Hi Everyone,

I have a doc with lots of sheets, I want to make one large PDF. with each sheet beging on its own page,

Every sheet is the same width but will vary in Length,

So this is what I need if I was writing it in English


Create a Pdf that will include ever sheet in Sheets "Sheet Name" Range A2:A205,
set each sheet page size to be One page wide and Length is last used Row (can be more than one page long)

please help if you can

Tony