title: How to add several images in excel using VBA?
body: <p>I am trying to add images in an Excel Sheet using ActiveSheet.Pictures.Insert
  I want to obtain the name of the pictures from activeCell and using it to add the images that have the same name in a specific folder, the code is like this:</p>
  <pre><code>
  Dim name As String, name1 As String
  
  name = ActiveCell.Value
  name1 = &quot;Folder location&quot; + name + &quot;_1.jpg&quot;
  
  ActiveSheet.Pictures.Insert( _
          name1).Select
  
  </code></pre>
  <p>the code works only for one cell, but them when I use another cell, with a different name of a picture that is also in the same folder, it only adds a square saying “The Picture can't be displayed”</p>
  <p>I am using Mac Os and Microsoft Excel 16.56</p>