Fixing Image In A Cell

[Faraz A. Qureshi]

Any way to insert a picture in a cell, fitted so as to set the row
height/column width accordingly and making the same of the exact size?

 

[Jacob Skaria]

Hi Faraz

Pictures reside in the different layer above the cells. You can move and
resize them to be on top of the cell; and format the picture to move and
resize with cells .

Dim myPic As Object
Set myPic = ActiveSheet.Pictures.Insert("C:\untitled.bmp")
With myPic
.Top = Range("B9").Top
.Left = Range("B9").Left
.Height = Range("B9").Height
.Width = Range("B9").Width
End With