This is probably a very easy fix but it is driving me nuts. I have some rectangles on the screen. I want to resize them. I recorded a macro that drags the top edge up and get this code:
Selection.ShapeRange.ScaleHeight (200), msoFalse, msoScaleFromBottomRight
The problem is when I run the code it resizes downward. Is there a way to force VBA to resize my rectangle up (i.e., anchor the bottom so it doesn't move)?