|
楼主 |
发表于 2017-4-18 14:05
|
显示全部楼层
Sub insertPic()
On Error Resume Next
Dim i As Integer
Dim FilPath As String
Dim rng As Range
Dim s As String
With ActiveSheet
Columns("a:a").ColumnWidth = 12 '调整A列为宽度为12PX
arr = Cells(Rows.Count, 2).End(3).Row '判读有多少行数据
For i = 2 To arr '变量 I 从2开始循环到 ARR
FIL = ActiveSheet.Range("B" & i) ' FIL 等于 B&数字 即定位单元格
If Left(FIL, 4) = "http" Then ' 如果 FIL 前4位=http then FilPath = ActiveSheet.Range("B" & i) '
FilPath = ActiveSheet.Range("B" & i) ' FilPath 等于 B&数字 即定位单元格
Else '否则 FilPath = ActiveSheet.Range("U" & i) '
FilPath = "" 'FilPath 取 U列单元格链接
End If
Set rng = .Cells(i, 1) '
With rng
ML = .Left
MT = .Top
MW = .Width
MH = .Height
ActiveSheet.Shapes.AddShape(msoShapeRectangle, ML, MT, MW, MH).Select
Selection.ShapeRange.Fill.UserPicture FilPath
End With
Rows(i).RowHeight = 145 '将行变成145px
.Cells(i, 1).Select
Next
End With
' MsgBox FIL
End Sub
|
|