Function FindImage(picname) As Object '根据A列名称找到B列图片
'单元格查找
Dim e As Shape
For Each e In Sheet2.Shapes
If e.TopLeftCell.Offset(0, -1) = picname Then
Set FindImage = e
Exit Function
End If
Next
Set FindImage = Nothing
End Function