Inserting Picture Excel Sheet

U

Ussiddiqui

Hi dudes !

Today i tried to insert picture in Excel Workbook, from VB , Actually i
dont know the exact funciton to do it , Telling you people , Who would
like to help me, if they already dont know that there is a function
available to insert the picture/logo on background of the excel sheet.
But i want to know the function to Insert the picture in to any
specific column or at any postion,

I will be very greatfull for the expert that will tell me this
problem's solution this night :)
 
R

Ron de Bruin

Try this example that place the picture in cell c1

Sub test()
Dim YourPic As Picture
With ActiveSheet.Range("c1")
Set YourPic = .Parent.Pictures.Insert("C:\Data\Picture 015.jpg")
YourPic.Top = .Top
YourPic.Width = .Width
YourPic.Height = .Height
YourPic.Left = .Left
End With
End Sub
 
U

Ussiddiqui

Hay who every you are ... you saved my deliverable ......
thanxxxxxxxxxxxxxxxxxxx Allotttttttt , message to Rena..........
 
Top