How to Move a Shape Without Selecting It?

Chloe Bennett
Chloe Bennett
• • 1 min read

How Can I Move Any Shape in a Sheet Without Selecting It? If I Use: Activesheet. Shapes. Range(Array("Picture 18")). Select Selection. Shaperange...

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

Must Read

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

Chloe Bennett

Culture, Media & Entertainment Columnist
Instagram Twitter Pinterest

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

Share this article
Twitter Facebook Pinterest