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

[µo°Ý] Ãö©óVBAÅܼưÝÃD

[µo°Ý] Ãö©óVBAÅܼưÝÃD

½Ð°Ý¤@­Ó°ÝÃD
¯B°Êªº¤j¼Æ¾Ú¡A§Q¥Îcountif¨ç¼Æºâ¥X¼Æ¶q
°²³]ºâ¥X¨Ó¼Æ¶q¬O35663¡A¦A§â¦C§R±¼¡A¦p¤U:
------------------------------------------------------------------
Sub ¥¨¶°1()

    Rows("2:35663").Select
    Selection.Delete Shift:=xlUp

End Sub

------------------------------------------------------------------
¨C¦¸»Ý­n¥Î¤â°Ê¦Û¤v¿é¤J©Ò±oªº¼Æ¶q
35663¬O¤@­ÓÅܼơA½Ð°Ý­n«ç»ò¼g¦¨VBA?¤£»Ý­n¦A¤â°Ê¿é¤J?

³o­Ó¦³¤GºØ¤è¦¡³B²z
Dim x As Long
    Dim Rows_Str As String
   
    'xÅܼƽЦۦæ³]©w
    Rows_Str = "2:" & CStr(x)
    Rows(Rows_Str).Delete shift:=xlUp
   
    '¥t¤@­Ó¤èªk¬O¥ÎRange¨Ó³B²z
    With ActiveSheet
        
        .Range(.Rows(2), .Rows(x)).Delete shift:=xlUp
   
    End With

³o¤G­Ó³£¯à¹F¨ì¬Û¦Pªº¥Øªº
clio

TOP

¦^´_ 5# c_c_lai


    À´¤F¡AÁÂÁ¡I

TOP

¦^´_ 4# chiang0320
x ¬°¤@­ÓÅܼƫ¬ºA«Å§i
§Aªº´£°Ý¡G ¬°¦ó""¤£¥Î¥]¨ìx   «o¦h¤F&
           Rows("2:x").delete     
"2:x" ³Qµø¬°¬O¤@­Ó¦r¦ê«¬ºA¡A°õ¦æ®É«h·|²£¥Í
------------------------
°õ¦æ¶¥¬q¿ù»~ '13'
«¬ºA¤£²Å¦X
------------------------
x = 35663
Rows("2:" & x).Delete

"2:" & x §Yµ¥©ó "2:35663"
©Ò¥H¤@¤Á§¡¯à¥¿±`°õ¦æ¡C

TOP

¦^´_ 2# ³X«È


    Rows("2:x").delete     ¬°¦ó¤£¯à¼g¦¨³o¼Ë¡H

¥¿½T¼gªk¡A¬°¦ó""¤£¥Î¥]¨ìx   «o¦h¤F&

TOP

¦^´_ 1# chiang0320
x = 35663
Rows("2:" & x).Delete

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD