- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 1# sandra_wang - Sub Ex()
- Dim Place%, Place_Row%, i%
- Place = 214
- Place_Row = 10
- With ActiveSheet
- If .Cells(Rows.Count, Place).End(xlUp).row >= Place_Row Then
- .Range(.Cells(Place_Row, Place), .Cells(Rows.Count, Place).End(xlUp)).Resize(, 6).Clear
- End If
- For i = 179 To 179 + (7 * 4) Step 7
- .Range(.Cells(Place_Row, i), .Cells(Rows.Count, i).End(xlUp)).Resize(, 6).Copy .Cells(Rows.Count, Place).End(xlUp).Cells(2, 1)
- Next
- End With
- End Sub
½Æ»s¥N½X |
|