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

[µo°Ý] ¦p¦ó§R°£©Ò¦³ªº¹Ï§Î

[µo°Ý] ¦p¦ó§R°£©Ò¦³ªº¹Ï§Î

¦b¬Y­Ó sheet ¤W¦³«Ü¦h¹Ï§Î¡A§Ú­n±N¨C­Ó¹Ï§Î§R°£, ¼g¤F¤U¦C³o¤@¬q,

¦ý¤@ª½¥X²{ ¦¹®ÉµLªk¶i¤J¤¤Â_¼Ò¦¡ ªºÄµ§iµøµ¡... ¨D¸Ñ....

Dim p As Shape
   
    For Each p In ActiveSheet.Shapes

            p.Delete     
      
  
    Next

google ¤@¤U¡A¬Ý¨ì¦³¤H¥Î "activesheet.shapes.delete" ³o­Ó¤èªk

¦ýÁÙ¬O¤£¦æ

TOP

¦^´_ 1# vanguarx
  1. For Each shap In ¤u§@ªí1.Shapes
  2.     shap.Delete
  3. Next
½Æ»s¥N½X

TOP

¤£¦æ­C...

Åã¥Ü shap ¥¼©w¸q

TOP

¸Õ¸Õ¬Ý

    Sheets("±z¿ï¾ÜªºSheet").Select
    ActiveSheet.Pictures.Delete

TOP

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