|
发表于 2011-12-16 17:25
|
显示全部楼层
本楼为最佳答案
本帖最后由 Zipall 于 2011-12-16 17:29 编辑
Sub test()
Dim p As String, r As Integer, c As Integer, i As Integer
p = ThisWorkbook.Path & "\"
For r = 2 To 6 Step 2
For c = 1 To 3
i = i + 1
With Cells(r, c)
Sheets("sheet1").Shapes.AddPicture p & i & ".jpg", False, True, .Left, .Top, .Width, .Height
End With
Next
Next
End Sub
|
|