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
- May 16 Wed 2007 20:37
how to insert picture to the cell?
close
全站熱搜
留言列表
發表留言