如何呀Excel中插入url鏈接圖片？

在c列中包含url鏈接，b列中下載插入c列鏈接中圖片，請大神為我出謀獻策

感謝親的邀請~

麻煩確認一下您要的效果是不是如下GIF所展示的嗎？如果是的話我就把操作步驟貼上來哦~~

按自我理解，先給出如下解決方案：

具體操作代碼如下：

Sub Test()

Dim Rng As Range

Dim Cell As Range

Dim Pic As Picture

Application.ScreenUpdating = False

Set Rng = Range("C2:C" Range("C" Rows.Count).End(xlUp).Row)

For Each Cell In Rng

With Cell

Set Pic = .Parent.Pictures.Insert(.Value)

With .Offset(, -1)

Pic.Top = .Top

Pic.Left = .Left

Pic.Height = .Height

Pic.Width = .Width

End With

End With

Next Cell

Application.ScreenUpdating = True

End Sub

感謝！