如何洗掉以某個字串開頭的形狀?
不需要回圈(?)只有一個“MyButton”,但“MyButton”后面的數字不同。
worksheets("sheet1").Shapes("MyButton" & "*").Delete
uj5u.com熱心網友回復:
您需要回圈檢查名稱。
Dim shp As Shape
For Each shp In Worksheets("Sheet1").Shapes
If shp.Name Like "MyButton*" Then
shp.Delete
End If
Next shp
轉載請註明出處,本文鏈接:https://www.uj5u.com/qianduan/383977.html
