I have an many embedded objects (shapes) in a worksheet and the icons is displayed inside a cell. How do I know the Cell range in which the shape object is displayed.
我在工作表中有许多嵌入对象(形状),图标显示在单元格内。如何知道形状对象的单元格范围。
Example: When I select a B2 and then select the object(shape) in the B17, and I query on the Cell.Address it shows B2 - how do I get the cell address as B17?
示例:当我选择B2然后在B17中选择对象(形状)时,我在Cell.Address上查询它显示B2 - 如何将单元格地址作为B17?
thanks
1 个解决方案
#1
4
You can use the Shape properties .TopLeftCell and .BottomRightCell to return the extents of the rectangular range that the shape overlaps. In your example, YourShape.TopLeftCell.Address should return $B$17
您可以使用Shape属性.TopLeftCell和.BottomRightCell返回形状重叠的矩形范围的范围。在您的示例中,YourShape.TopLeftCell.Address应返回$ B $ 17
#1
4
You can use the Shape properties .TopLeftCell and .BottomRightCell to return the extents of the rectangular range that the shape overlaps. In your example, YourShape.TopLeftCell.Address should return $B$17
您可以使用Shape属性.TopLeftCell和.BottomRightCell返回形状重叠的矩形范围的范围。在您的示例中,YourShape.TopLeftCell.Address应返回$ B $ 17