title: Excel VBA Resize picture in a certain range
body: <p>Ok i have an image that a 3rd part software is placing into an excel file.  in order to get the resolution needed it has to be sized much larger than needed.  It will always be placed in the same location and be a specific size.  I need to resize it.  Ideally it would be automatic when the excel file opens but i think any vba code would end up acting before the information is inserted, but if there was a small delay that would be cool too.  Alternatively i could make do with a button that runs a bit of code.  The code below works, but only when the picture is specifically named "Picture 179" which it won't be ever again or at least until the counter recycles.</p>
  
  <p>The image is inserted at Cell A45 specifically but it extends through roughly cell AZ60.</p>
  
  <p>Here is what i've got that doesn't work.</p>
  
  <pre><code>Private Sub Resize_Graph_Click()
     ActiveSheet.Shapes.Range(Array("Picture 179")).Select
     Selection.ShapeRange.Height = 104.4
     Selection.ShapeRange.Width = 486.72
  End Sub
  </code></pre>