title: VBA - Range to jpg picture
body: <p>I'm trying to get a jpg file from a specific range in excel</p>
  
  <p>I'm currently getting the </p>
  
  <blockquote>
    <p>1004 Runtime error on Range method from _Worksheet object.</p>
  </blockquote>
  
  <p>This is what my code looks like:</p>
  
  <pre><code>Sub Export()
  
  Dim ws As Worksheet
  Dim Rng As Range
  Dim Chrt As Chart
  
  Set ws = ActiveSheet
  Set Rng = Range("B2:H11")
  
  ws.Range(Rng).CopyPicture
  Set Chrt = Charts.Add
  
  With Chrt
      .Paste
      .Export FileName = "Case.jpg", Filtername:="JPG"
  End With
  
  End Sub
  </code></pre>