Macro to Save range as CSV

Hello everyone,

I have the following code which saves a specific range in my active workbook as a CSV in a particular folder.
My issue is, the CSV that is created has a single sheet that is always named the same as the CSV itself. I would like it if the sheet would just be named "Sheet1" , is that possible by modifying the below code?

Please Login or Register  to view this content.

Any help is muchly appreciated!

Paul

Yes! makes perfect sense. Thank you David!