Resize an image to match a cell

Hello Gboy,

The key is to use common properties. Both the Cell and the Image share 2 properties relating to they're size: Height and Width.

Example:

With Range("E5")
  .Height = Image1.Height
  .Width = Image1.Width
End With

Change Image1 to the name of the object you are using in your code.

Sincerely,
Leith Ross