Prev: Marker option for Excel XY charts
Next: Change font on dropdown menu items
From: Faraz A. Qureshi on 1 Feb 2010 07:01
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
From: Jacob Skaria on 1 Feb 2010 07:16
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
 | 
Pages: 1
Prev: Marker option for Excel XY charts
Next: Change font on dropdown menu items