Macros and Programming

Hi-

I'm stuck and was hoping someone could help me!

I'm trying to create a macro that will save a selection of the current workbook (cells G14 to AS43) to the desktop (and prompt me to enter the save as name). I'm hoping to keep the formatting and opening this range in a new doc seems to lose that. Help?

Looking to also do the same thing as a PDF.

THANK YOU!!

Please try an Excel forum.
This forum is about Cardbox.