Selecting



Dim oSelection As Object 
Dim oShapeRange As Excel.ShapeRange
Dim oShape As Excel.Shape

Set oSelection = Application.Selection
If (TypeName(oSelection) = "Rectangle") Then
   Set oShapeRange = oSelection.ShapeRange
   set oShape = oShapeRange(1)
End If

set oShape = ActiveSheet.Shapes.Item(1)



© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext