Home » Cloud Investing Network » How to Move a Shape Without Selecting It?

How to Move a Shape Without Selecting It?

Chloe Bennett • • 1 min read
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

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.

Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.