Inserting Picture Excel Sheet

  • Thread starter Thread starter Ussiddiqui
  • Start date Start date
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 :-)
 
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
 
Hay who every you are ... you saved my deliverable ......
thanxxxxxxxxxxxxxxxxxxx Allotttttttt , message to Rena..........
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top