添加一个子程序:
Sub 添加校徽(R As Range)
For I = 8 To 265 Step 257 '考虑图片位置
ActiveSheet.Pictures.Insert(ThisWorkbook.Path & "\校徽.png").Select
With Selection.ShapeRange
.LockAspectRatio = msoTrue
.Height = 46.5
.Left = I
.Top = R.Top - 50 '需根据实际情况调整数据
End With
Next
End Sub