Shape对象的Type属性有如下这些类型,当对单元格中的图形对象进行操作前,可以先判断类型,例如将单元格中的图片位置放置于左上角: Dim Sp As Shape Dim Rng As Range If Sp.Type = msoPicture Then '判断shape的类型是否图片,可以用值13代替msoPicture Set Rng = S...
Shape对象的Type属性有如下这些类型,当对单元格中的图形对象进行操作前,可以先判断类型,例如将单元格中的图片位置放置于左上角: Dim Sp As Shape Dim Rng As Range If Sp.Type = msoPicture Then '判断shape的类型是否图片,可以用值13代替msoPicture Set Rng = S...