title: VBA: Copy cells, paste as a picture, then save as a picture?
body: <p>I have the following code:</p>
  
  <pre><code>Range("A1:M28").CopyPicture Appearance:=xlScreen, Format:=xlPicture
  
  Sheets.Add.Name = "Without Formatting"
  Worksheets("Without Formatting").Paste _
  Destination:=Worksheets("Without Formatting").Range("A1:M28")
  </code></pre>
  
  <p>That copies some cells then pastes them as a picture in another worksheet, is there a way of saving the picture (preferably as a jpeg) into a specific location so that I can then use the picture in an email?</p>