in reply to Re^2: Save Excel worksheets as PDF
in thread Save Excel worksheets as PDF

I totally missed that the OP might be using Excel 2007.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James