你说的真好,你看看这段代码该如何修改,才能使照片自动填满J3单元格
Sub 打印()
For Each s In ActiveSheet.Shapes
If s.Name Like "Picture*" Then s.Delete
Next
For i = [m4] To [m5] Step 1
[m2] = i
er = Sheets("原始表").[a65536].End(xlUp).Row
单位 = Application.VLookup(i, Sheets("原始表").Range("$A$2:$O$" & er), 2)