I have this code and it produces a jpeg of the range that I select and stores the file in the place i have designated for it. However the problem I have is that it produces a new sheet in the work book which i don't want, if anyone has any ideas that would be a great help.
Private Sub...