Save range as pdf, naming and asking where to put

[HereComesTheBoom]

So I wanna save range A1:F66 as a pdf and name it "Budget (cell C1 & D1)" - and then ask me where to save it.

I know it's probably been asked before and I could piece the answer together out of a couple of threads, but I cant seem to locate an answer that'll easily let me combine all the parametres.

[kev_]

Try this

Put code in general module:

Please Login or Register  to view this content.

Default browse to path:
- code defaults to the same path as the workbook
- to default somewhere else, replace the red text with full path in quotes

Please Login or Register  to view this content.

eg

Please Login or Register  to view this content.