View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
TFriis TFriis is offline
external usenet poster
 
Posts: 22
Default InserPictureInRange method for excel VBA

Thank you - I was looking for that code :)

This is not a standard function of Excel

You can also use this

Sub Test()
Dim myPict As Picture
With ActiveSheet.Range("B5")
Set myPict = .Parent.Pictures.Insert("C:\FolderName
\PictureFileName.gif")
myPict.Top = .Top
'myPict.Width = .Width
'myPict.Height = .Height
myPict.Left = .Left
myPict.Placement = xlMoveAndSize
End With
End Sub