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

½Ð°Ý¦p¦ó§â¹Ï¤ùdel

½Ð°Ý¦p¦ó§â¹Ï¤ùdel

Sheet2 ¦³±o¦h¹Ï¤ù·Q1¦¸¹Ldel,¦ý¤£¥i¥Hdel  Sheet2.
½Ð°ª¤â«ü±Ð.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# basarasy


¸Õ¸Õ³o­Ó   
For Each p In sheet2.Shapes
    On Error Resume Next
    p.delete
Next

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-6-27 15:36 ½s¿è

³o½g¤£¥Îvba´N¥i¥H¸Ñ¨M
¥Î¨ìvba? ¥i¯à§â¥L½ÆÂø¤Æ¤F

+++++++++++++++++++++++++++++++++++++++++++
¥Î"¨ì"³o­Ó¥\¯à´N¥i¥H¸Ñ¨M

1.¦b2007ª© ¥Î   ±`¥Î/´M§ä»P¿ï¨ú/¨ì/¯S®í/ª«¥ó  ·|¿ï¨ú¹Ï¤ùµ¥ª«¥ó
2.µM«á«ö Áä½Ldel

TOP

¦^´_ 4# HUNGCHILIN

¦]¬°­n­«½Æ°µ¦n¦h¦¸§Ú¤~¥Îvba.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

Sub Macro1()
ActiveSheet.DrawingObjects.Select
Selection.Delete
End Sub

TOP

¦^´_ 6# HUNGCHILIN

ÁÂÁ§A
¦ý¦³­Ó°ÝÃD,¬O§Ú­ndel  Sheet2ªº¹Ï.
¤§«á§Ú§ï¦¨

Sheet2.Range("B1").Select
ActiveSheet.DrawingObjects.Select
Selection.Delete

¥X²{¿ù»~><

²{¦b§Ú¥Î victorl ¤j¤jªºvba ok¤F.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 7# basarasy
    Sheet2.Range("B1").Select
½Ð°Ý°õ¦æ³oµ{¦¡½X®É §@¥Î¤¤ªº¤u§@ªí¬OSheet2¶Ü?
¦p¤£¬O ·íµM·|¿ù»~ªº

TOP

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-6-28 21:33 ½s¿è

¦^´_ 8# GBKEE

§Ú¦bSheet1 ªº¦a¤è¥Îµ{¦¡½X ¦ý§Ú­ndelªº¦a¤è¬OSheet2  ­n¤°¼Ë¼g?
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ oobird ©ó 2010-6-28 22:38 ½s¿è

Sub yy()
Dim shp As Shape
For Each shp In Sheet2.Shapes
    If shp.Type = msoPicture Then shp.Delete
Next
End Sub
ÁקK»~§R¹Ï¤ù¥H¥~ªºª«¥ó¡I

TOP

¦^´_ 9# basarasy
    With Sheet2.DrawingObjects
         .Delete
     End With

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD