Fixing Image In A Cell

  • Thread starter Faraz A. Qureshi
  • 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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top