Multiple print ranges within one worksheet VBA

[davec8723]

Hi,

I am looking for a code which can select two seperate print ranges within the same worksheet.

For example, I would like to print A1:C10 and A15:F40, with one macro.

I do not want the code to simply print twice selecting a different range each time, as I want to print this as an Adobe PDF and save the output in one file.

Any help woule be very much apprecaited as I am stuck!!!!!

 

[Mohammad Basem]

You can define multiple print areas in the page setup dialog box, e.g.

Print area: A1:C10,A15:F40