Macro to print specific pages in a single worksheet (2007)

Hi,

I am new to using VBA so any help would be very much appreciated. My current problem exists due to the fact that Excel 2007 does not have the ability to select multiple ranges to print, so I thought I would have a go at using VBA.

To go into more detail of what I need help with;

I have a worksheet containing multiple pages (Created by print area button) which need to converted to pdf. However not all pages are likely to be needed to print, just those that contain the relevant information that is filled in. To complicate matters the last page or summary page needs to be printed on every occasion.

So in Short;

34 pages in total.
If 10 are in use then I would need pages 1-10 + page 34.

I have gone so far as to include a formula in a cell (eg.A1) that will count the necessary pages that need printed ^1-10^, I though this may be helpful in the coding.

As I said my knowledge with VBA is very limited so any help would be very appreciated.

Thankyou