ExcelBanter - Activesheet.Pictures.Insert

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Activesheet.Pictures.Insert (https://www.excelbanter.com/excel-programming/277846-activesheet-pictures-insert.html)

dchow

Activesheet.Pictures.Insert

Can I control the position and size of the picture programmatically?

Bill Li

Activesheet.Pictures.Insert

ActiveSheet.Pictures.Insert("L:\untitled2.bmp").Se lect
Selection.ShapeRange.ScaleWidth 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.IncrementLeft 164.25
Selection.ShapeRange.IncrementTop 81.75

-----Original Message-----
Can I control the position and size of the picture
programmatically?
.

dchow

Activesheet.Pictures.Insert

Thanks.

On Tue, 23 Sep 2003 16:49:54 -0700, "Bill Li"
wrote:

ActiveSheet.Pictures.Insert("L:\untitled2.bmp").Se lect
Selection.ShapeRange.ScaleWidth 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.IncrementLeft 164.25
Selection.ShapeRange.IncrementTop 81.75

-----Original Message-----
Can I control the position and size of the picture
programmatically?
.

All times are GMT +1. The time now is 02:22 AM.