101 Tip & Trik
Wednesday, March 21, 2012
Excel: excel Cannot shift object off sheet
Warning : excel Cannot shift object off sheet
Sub Test()
Dim s As Shape
On Error Resume Next
For Each s In ActiveSheet.Shapes
s.Placement = xlMoveAndSize
Next
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment