|
发表于 2015-1-31 10:57
|
显示全部楼层
本楼为最佳答案
Sub test()
Dim shp As Shape, l, t, w, h, x
l = 0: t = 0: w = 480: h = 320: x = 20 '间隔
For Each shp In ActiveSheet.Shapes
If shp.Type = msoPicture Then
t = t + x '每次的间隔
With shp
.Top = t: .Left = l: .Width = w: .Height = h
End With
t = t + h '高度累计增加
End If
Next shp
End Sub
2.rar
(103.92 KB, 下载次数: 27)
|
|