close

Can someone help me? I am trying to embed a picture within a cell, not copy
and paste or insert picture, I want to be able to see the image in a cell
not
outide the grid.

and if it's possible

No, it is not possible
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Johney Salemquot; lt;Johney gt; wrote in message
...
gt; Can someone help me? I am trying to embed a picture within a cell, not
gt; copy
gt; and paste or insert picture, I want to be able to see the image in a cell
gt; not
gt; outide the grid.
gt;
gt; and if it's possible
Hi Johney

Try this to insert into the activecell

Sub test()
On Error Resume Next
Set pic = ActiveSheet.Pictures.Insert(quot;C:\range.gifquot;)
On Error GoTo 0
If Not pic Is Nothing Then 'The picture exists
Set rng = ActiveCell
With pic
.Height = rng.Height
.Width = rng.Width
.Left = rng.Left
.Top = rng.Top
End With
End If
End Sub--
Regards Ron de Bruin
www.rondebruin.nlquot;Johney Salemquot; lt;Johney gt; wrote in message ...
gt; Can someone help me? I am trying to embed a picture within a cell, not copy
gt; and paste or insert picture, I want to be able to see the image in a cell
gt; not
gt; outide the grid.
gt;
gt; and if it's possible

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()