Setting the Height and Width of an Image

[NaNaBoo]

Is there a way to set the Height and Width of an image that is copied to certain dimensions.

I would like my image to be set to a "Height" of 6.07 and "Width" of 8.90.

I now you can do this manually when you go in Format Picture and resize the image to these dimesions.

Can this be done with a code?

[dominicb]

Good afternoon NaNaBoo

I now you can do this manually when you go in Format Picture and resize the image to these dimesions.

Can this be done with a code?

Yes, try recording it with the macro recorder (Tools > Macro > Record New Macro).
Remember to release the "Lock Aspect Ratio" setting. This is the code that I got (picture needs to be selected) :

Sub Macro1()
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Height = 171.75
Selection.ShapeRange.Width = 252#
End Sub

HTH

DominicB

[NaNaBoo]

Thanks for the insight.

I will try it out.