If you want to save a selection to a folder you should be able to use one of these suggestions.

John Peltier at
https://www.mrexcel.com/forum/excel-...lls-jpg-2.html
Post #16

RoryA
https://www.mrexcel.com/forum/excel-...g-chart-2.html
Post #11

Stephen Bullen is mentioned also. I have used his code but that was quite a few years ago.