converting only cetain sheets to pdf

I have the following macro to convert excel files to pdf. but I only want to convert sheet 1, sheet 2, and sheet 3. The macro is converting all the complete excel files which are 16 sheets. please help:

Please Login or Register  to view this content.

Hi there,

Try using:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

I add your code but it comes up in 'red' in vba editor. it looks like this, if you can paste the entire code please.

Please Login or Register  to view this content.

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help (if only slightly )

Best regards,

Greg M