- ©«¤l
- 151
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 197
- ÂI¦W
- 14
- §@·~¨t²Î
- windwos 7
- ³nÅ骩¥»
- 64bit
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2017-5-29
- ³Ì«áµn¿ý
- 2024-4-18
|
¦^´_ 2# adrian_9832
Sub test()
lastrow = Range("A1").CurrentRegion.Rows.Count
For i = 1 To lastrow
s = s & Cells(i, 1) & IIf(i Mod 5 = 0, vbNewLine, IIf(i = lastrow, "", ","))
Next i
MsgBox s
End Sub |
|