VBA - Open Save As dialogue box - to save named range

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

Thanks nathansav.
I'm a relative vba novice, and having looked it up I cant work out what I's supposed to do.

To shed a little more light:

I have sourced the following macro that saves the named range selection as pdf - but to a fixed location/filename:

Please Login or Register  to view this content.

I need to amend/change this so that it Opens the Save As box first, to give me the option to amend the file path / filename before actually saving.

Thanks

Ok I tried this, and it brings up the Save As dialog box. But that's all it seems to do?

I want it to pre select save as PDF (with my named range selection only selected).

Ok I tried this, and it brings up the Save As dialog box. But that's all it seems to do?

I want it to pre select save as PDF (with my named range selection only selected).

I sorted it myself:

Please Login or Register  to view this content.