怎么判断excel中是否包含插入的图片？
发布网友
发布时间：2022-04-22 14:31
共1个回答
热心网友
时间：2022-07-12 01:06
EXCEL 判断一个单元格中是否有图片
比如判断[D8]单元格里有无图片：
Sub MACRO1()
Dim SH As Shape, HASPIC As Boolean
For Each SH In ActiveSheet.Shapes
If Application.Intersect(Range(SH.TopLeftCell.Address, SH.BottomRightCell.Address), [D8]) Is Nothing Then HASPIC = True: Exit For
Next
MsgBox "[D8]单元格里" & IIf(HASPIC, "", "没") & "有图片"
End Sub
