Forum Discussion
Excel VBA Shape Rotate makes unwanted Move and Resize to Shape Group.
A shape group is getting resized after VBA rotation. The attached Excel 2016 / Office 365 workbook contains a worksheet with 2 sets of shapes: Triangle 1 and Circle 1 (Ungrouped) Triangle 2 an...
I am fully updated.
If you look closely at the result image, you will see the image on the right is slightly larger. I am guessing you only entered a value into cell H4 one time. If you enter any value several more times, pressing enter after each entry, I think you will see the changes more clearly.
Also, right click and select size and properties. This should show the same value for height and width for the grouped object. If it does not, then you have replicated my situation.
Ok, I confirm the issue!
It seems like the grouping causes this weird bug!
You can send feedback to the Excel Team about it.
For now, the workaround is to forget the grouping!
Regards