Fixing Image In A Cell

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

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?
 
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
 
Back
Top