如何检查一个单元格是否有图片？ [英] How to check if a cell has a picture?

问题描述

在Excel中，我想检查一个特定的单元格，例如C12是否有图片？

我该怎么做？

In Excel, I want to check if a specific cell for instance "C12" has a picture?
How could I do this?

推荐答案

您可以循环使用工作表的Shapes集合，寻找一个形状，其 .TopLeftCell 具有与目标范围相同的地址。

You do this by looping through Shapes collection of the worksheet, looking for a shape whose .TopLeftCell has same address as your target range.

这篇关于如何检查一个单元格是否有图片？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！