- ©«¤l
- 361
- ¥DÃD
- 57
- ºëµØ
- 0
- ¿n¤À
- 426
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- 2003,2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-13
- ³Ì«áµn¿ý
- 2022-12-8
|
¦^´_ 6# coke373
Book1.zip (9.14 KB)
- Sub ex()
- k = Sheets(2).Cells(9, Columns.Count).End(xlToLeft).Column
-
- For i = 11 To 96
- Sheets(2).Cells(i - 9, k + 1) = Sheets(1).Cells(i, 3)
- Next
-
- For i = 107 To 120
- Sheets(2).Cells(i - 19, k + 1) = Sheets(1).Cells(i, 3)
- Next
-
- For i = 137 To 139
- Sheets(2).Cells(i - 35, k + 1) = Sheets(1).Cells(i, 3)
- Next
-
- Sheets(2).Cells(1, k + 1) = Format(Year(Date), "0000") & Format(Month(Date), "00") & Format(Day(Date), "00")
- End Sub
½Æ»s¥N½X |
|