|
发表于 2012-7-4 17:05
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim i As Integer, r As Integer, c As Integer
-
- Application.ScreenUpdating = False
- Sheet5.Select
- Call test1
-
- For i = 0 To 9
-
- '指定单元格
- r = Int(i / 2) * 10 + 1
- c = IIf(i Mod 2, 8, 1)
- Cells(r, c).Activate
-
- '复制图片到同屏
- Sheet1.Range("ao1") = i
- Sheet1.Shapes("圖表 3").CopyPicture
- ActiveSheet.Paste
-
- '只为方便查找。可以不要。
- Selection.Name = "圖" & i
- '按指定的比例调整形状的高度
- Selection.ShapeRange.ScaleHeight 0.23, msoFalse, msoScaleFromTopLeft
-
- Next i
-
- MsgBox "ok"
-
- End Sub
-
-
-
- Sub test1() '删除当前工作表中的所有图片
- Dim shp As Shape
- For Each shp In ActiveSheet.Shapes
- If shp.Type = msoPicture Then shp.Delete
- Next
- End Sub
复制代码
K線系統_回复.rar
(811.35 KB, 下载次数: 11)
|
|