ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦p¦ó¤@¦¸¹L§R°£ (ª½½u±µÂI)¹Ï®×?

¦^´_ 1# idsmchow
·Q½Ð°Ý (ª½½u±µÂI)¹Ï®×, ¬O§_·|¼vÅT¥¨¶°ªº¹B§@?
¬O§A(ª½½u±µÂI)¹Ï®×¤Ó¦h¤F (1435 ) ÀÉ®×Åܤj  
   
  1. Sub Ex()
  2.     MsgBox ActiveSheet.Shapes.Count
  3. End Sub
½Æ»s¥N½X

TOP

¦^´_ 4# idsmchow
  1. Sub Ex()
  2.     Dim A As Integer
  3.     For A = 5 To 252
  4.         With Sheets(Sheets("Table").Cells(A, 2).Text)
  5.             .Activate
  6.             .Shapes.SelectAll
  7.             Selection.Delete
  8.         End With
  9.     Next
  10. End Sub
½Æ»s¥N½X

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¤Hªº§Ö¼Ö¡D¤£¬O¦]¬°¥L¾Ö¦³±o¦h¡A¦Ó¬O¦]¬°¥L­p¸û±o¤Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD