10-26-2010, 12:09 AM
Hi,
Someone can help me how i can insert a picture to the specified range?
Even if i specify range, it insert the picture outside the range.
below code inserts the picture but taking too much space on the excel sheet. Below code should insert the picture only from d3 to f3 but instead it inserts in almost entire sheet.
Thanks.
safi
Someone can help me how i can insert a picture to the specified range?
Even if i specify range, it insert the picture outside the range.
below code inserts the picture but taking too much space on the excel sheet. Below code should insert the picture only from d3 to f3 but instead it inserts in almost entire sheet.
Code:
objWorkbook1.ActiveSheet.range("d3:f3").Select
objWorkbook1.ActiveSheet.Pictures.Insert("C:\Documents and Settings\msafiullah\Desktop\error.bmp")
Thanks.
safi