NewOrderFac33
Well-known Member
- Joined
- Sep 26, 2011
- Messages
- 1,275
- Office Version
- 2016
- 2010
- Platform
- Windows
Good afternoon,
If I want to move a shape on a worksheet, the following recorded code works:
but the following doesn't:
reporting "Object doesn't support this property or method"
It seems a bit inefficient to have to keep selecting the shape before I move it.
Would anyone care to point out how remarkably stupid I'm being?
Regards
Pete
If I want to move a shape on a worksheet, the following recorded code works:
Code:
ActiveSheet.Shapes.Range(Array("Rounded Rectangle 2")).Select
Selection.ShapeRange.IncrementLeft 0.1
Code:
ActiveSheet.Shapes("Rounded Rectangle 2").ShapeRange.IncrementLeft 0.1
It seems a bit inefficient to have to keep selecting the shape before I move it.
Would anyone care to point out how remarkably stupid I'm being?
Regards
Pete