How to move a shape without selecting it?

How can I move any shape in a sheet without selecting it?

If I use:

 ActiveSheet.Shapes.Range(Array("Picture 18")).Select Selection.ShapeRange.IncrementLeft -76"

it appears an edition border around the shape.

0

2 Answers

ActiveSheet.Shapes("Picture 18").IncrementLeft -76
3
Application.ScreenUpdating = False
Set s = Worksheets("sheet1").Shapes(1)
s.Left = 100
Application.ScreenUpdating = True

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

You Might Also Like