ªð¦^¦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 : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD