Hsieh

¦^´_ 1# aoss98

1. Sub nn()
   
2. Set Rng = Range([B1], [B65536].End(xlUp)).SpecialCells(xlCellTypeConstants)
   
3. For i = 1 To Rng.Areas.Count
   
4.    Set a = Rng.Areas(i)
   
5.    For Each b In a
   
6.       b.Offset(, -1) = i
   
7.    Next
   
8. Next
   
9. End Sub

½Æ»s¥N½X

aoss98

ÁÂÁ basarasy, luhpro ¨â¦ì«ü敎¡A°ÝÃD¤w¸Ñ¨M!!

kimbal

³o­Ó¤£¤@©w­n¥Îvba
°²³]¶}©l¦b A2 (§YB2=1234)
¦bA2 ¿é­Ó 1 (¦]¬°B2¦³ªF¦è)
¦bA3 ¿é³o­Ó¤½¦¡ = IF(B3="", "", IF( A2="", A1+1 , A2 ))

luhpro

Dim iI%, iNum%, bCheck As Boolean, bNext As Boolean

  iI = 0
  iNum = 1
  bNext = False
  bCheck = True

  With Sheets(1)
    While bCheck
      iI = iI + 1
      If .Cells(iI, 2) <> "" Then
        .Cells(iI, 1) = iNum
        bNext = False
      Else
        If bNext = True Then
          bCheck = False
        Else
          iNum = iNum + 1
          bNext = True
        End If
      End If
    Wend
  End With

³æ¯Â°w¹ï¨C¤@­Ó¥i¯à¦C¥X­n°µªº¨Æ,
µM«áª`·N¤£­n¥X²{µL­­°j°é§Y¥i.

basarasy

¦^´_ 1# aoss98

1. Sub Macro1()
   
2. '
   
3. ' Macro1 Macro   
   
4. MyBRow = 1
   
5. MyANo = 1   
   
6.    
   
7.     Range("B65536").Select
   
8.    Selection.End(xlUp).Select   
   
9.    MyRow = Selection.Row   
   
10.     Do   
    
11.     If Range("B" & MyBRow).Value = "" Then   
    
12.     MyBRow = MyBRow + 1   
    
13.     MyANo = MyANo + 1
    
14.     Else     
    
15.     Range("A" & MyBRow).Value = MyANo   
    
16.     MyBRow = MyBRow + 1        
    
17.     End If   
    
18.     Loop Until MyBRow = MyRow + 1           
    
19. End Sub

½Æ»s¥N½X

§Ú¥u·|¥Î¤@¯ëªºvba ><