View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Fixing Image In A Cell

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


--
Jacob


"Faraz A. Qureshi" wrote:

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?
--
Thanx in advance,
Best Regards,

Faraz