|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub Export3()
- Sheets("图片").Activate
- Dim cel As Range, m&, n&, x&, y&, p As Shape
- For Each p In ActiveSheet.Shapes
- p.Cut
- Next
- For Each cel In Sheets("原图").Range("b2:c3")
- m = m + 1: n = n + 1
- cel.CopyPicture Appearance:=xlScreen, Format:=xlPicture
- If m = 1 And n = 1 Then
- Set rng = Application.InputBox("请选择单元格", "系统提示!", Type:=8)
- rng.Select
- Else
- x = IIf(m = 2, 0, 1)
- y = IIf(n = 3, 0, 1)
- rng.Offset(x, y).Select
- End If
- ActiveSheet.Paste
- Next
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|