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

[µo°Ý] ¬y¤ô¸¹

[µo°Ý] ¬y¤ô¸¹

Dear,
§Ú·Q¥HBÄ檺¸ê®Æ¦C¼Æ¬°·Ç,¦bAÄæ¦Û°Ê²£¥Í¬y¤ô¸¹(±qA2¶}©l¥H1.2.3¶ñ¤J)
¥i¬O¥X²{³£¬OBÄ檺Á`¦C¼Æ,½Ð°Ý¬O­þ­Ó¨BÆJ...¦³°ÝÃD??
        With Workbooks("²z³f³æ.xlsx").Sheets("­q³æ")
            Workbooks("²z³f³æ.xlsx").Sheets("­q³æ").Activate
            xRow = Cells(Cells.Rows.Count, "B").End(xlUp).Row
        J = 1
    For J = 1 To xRow
        Range("A2:A" & xRow).Value = J
        J = J + 1
    Next
        End With
End Sub

¦^´_ 1# PJChen
¸Õ¸Õ¬Ý
With Workbooks("²z³f³æ.xlsx").Sheets("­q³æ")
   Workbooks("²z³f³æ.xlsx").Sheets("­q³æ").Activate
   xRow = Cells(Cells.Rows.Count, "B").End(xlUp).Row
   i = 1
   For j = 2 To xRow
      Range("A" & j).Value = i
      i = i + 1
   Next
End With

TOP

¦^´_ 2# jcchiang

¥i¥H¥¿±`¶]¥X¬y¤ô¸¹¤F....·PÁÂ

TOP

        ÀR«ä¦Û¦b : «Î¼e¤£¦p¤ß¼e¡C
ªð¦^¦Cªí ¤W¤@¥DÃD