VBA: Making a shape the same size as a range

[musoguy]

I am attempting to run write a code that will insert a shape } and size it to the same size as a range. The range will change size every time the macro runs, but will always be vertical. For example, if the range is G10:G20 I want the shape to be the same vertical size, and appear somewhere around column H. Is this even possible? I can figure out how to create the shape, but the sizing issue is beyond me. Hoping someone can help.

James

 

[Jaafar Tribak]

Maybe this :

Sub Test()

    With ActiveSheet.Range("G10:G20")
        .Parent.Shapes.AddShape msoShapeRightBrace, _
        .Offset(, 1).Left, .Top, .Width, .Height
    End With
    
End Sub

 

[musoguy]

That would do it! Thank you so much for your help, you're a life saver