Sub Test() Dim s As Shape Dim Width As Double Dim Height As Double Dim AspectRatio As Double Width = 150 Height = 150 For Each s In ActivePage.Shapes If s.Type = cdrBitmapShape Then 'so if thewidth is greater than theheight If s.Bitmap.SizeWidth > s.Bitmap.SizeHeight Then 'the aspect ratio is Height divided by Width AspectRatio = s.Bitmap.SizeHeight / s.Bitmap.SizeWidth Height = AspectRatio * Width 'height is greater than width, so ElseIf s.Bitmap.SizeHeight > s.Bitmap.SizeWidth Then 'the aspect ratio is Width divided by Height AspectRatio = s.Bitmap.SizeWidth / s.Bitmap.SizeHeight Width = AspectRatio * Height End If s.Bitmap.Resample CLng(Width), CLng(Height) End If Next sEnd Sub