- ©«¤l
- 1572
- ¥DÃD
- 16
- ºëµØ
- 2
- ¿n¤À
- 1521
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2003
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2016-1-13
|
- Sub Ex()
- Dim i%
- With Sheets("½s¸¹")
- For i = 1 To .[h2]
- Sheets("Sheet1").[A1:G1].Offset(i) = .[A2:G2].Value
- Sheets("Sheet1").[A1:G1].Offset(i).Cells(4) = Mid(.[d2], 1, 11) & Format(i, "0000000")
- Next
- End With
- End Sub
½Æ»s¥N½X «ü©wªí¦W§Y¥i¡C |
|