Hi

I need to have a macro button that Opens the Save As dialogue box, with PDF already selected. But it needs to save for a Named Range ("Scores") only.

I needs to have the option to save to different files each time, and different names - thus why it needs to Open the Save As box - and not actually save. I have some code that will save the named range as a pdf to a pre-determined place that works fine - but not what I need.

Any help would be much appreciated.

Cheers