I created a Macro to PDF certain pages of an Excel sheet using the following
code

ActiveWindow.View = xlPageBreakPreview
Range("A1:G86,A172:G263").Select
Range("A172").Activate
Application.ActivePrinter = "Adobe PDF on Ne06:"
ActiveWindow.Selection.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne06:", Collate:=True
ActiveWindow.View = xlNormalView
Range("B7").Select

A week later when I went to use the macro it failed as the Printer is now:

Adobe PDF on Ne08

How can I set the macro to always find the "Adobe PDF" printer no matter
what situation or "Ne" that it sits on?.

Iam currently using Adobe Pro 6. As a matter of interest, are there any
versions of Adobe writer that allow you to PDF a selection of cells whether
contiguous or non-contiguous?

Any assistance would be greatly appreciated.