ªð¦^¦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 : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD