Sub 对号插图()Dim st As String, c As Integer, i As Integer
For c = 1 To 2000
If Cells(c, 1) = "" Then
st = ""
Else:
st = ActiveSheet.Cells(c, 1).Value
With ActiveSheet.Pictures.Insert("D:\360data\桌面\111\" & st)
.Select
.ShapeRange.LockAspectRatio = msoFalse
.Placement = xlMoveAndSize
.ShapeRange.Left = Cells(c, 2).Left
.ShapeRange.Top = Cells(c, 2).Top
.ShapeRange.Height = Cells(c, 2).Height
.ShapeRange.Width = Cells(c, 2).Width
End With
End If
Next c
End Sub
|