Guest User

Untitled

a guest
Dec 7th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. Sub ShapeTest()
  2.  
  3. Dim ActiveShape As Shape
  4. Dim ShapeCell As Range
  5.  
  6. Application.ScreenUpdating = False
  7.  
  8. Set ShapeCell = ActiveSheet.Range("A1")
  9. Set ActiveShape = ActiveSheet.Shapes.AddShape(msoShapeRectangle, ShapeCell.Left, ShapeCell.Top, ShapeCell.Width, ShapeCell.Height)
  10.  
  11. ActiveSheet.Rows(1).Insert shift:=xlShiftDown
  12.  
  13. Application.ScreenUpdating = True
  14.  
  15. End Sub
Add Comment
Please, Sign In to add comment