View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do i select an inserted image.

Hi,

Try this

Note by default Excel wil put a space in Picture 18 and if your picture has
that then so must the code.

Dim myPict As Picture
With ActiveSheet.Range("P2")
Set myPict = .Parent.Pictures("Picture18")
myPict.Top = .Top
myPict.Left = .Left - 50
myPict.Placement = xlMoveAndSize
End With


Mike


"SpeeD" wrote:

Hi.

I need to select an allready inserted image and align it to a cell, But i
can“t make my code works.
What am i doing wrong???

Thansk in advance
SpeeD

Dim myPict As Picture
With ActiveSheet.Range("p2")
Set myPict = ActiveSheet.Shapes("Picture18")
myPict.Top = .Top
myPict.Left = .Left - 50
myPict.Placement = xlMove
End With