- 最後登錄
- 2022-11-24
- 在線時間
- 1 小時
- 註冊時間
- 2008-9-2
- 閱讀權限
- 20
- 精華
- 0
- UID
- 4896884
- 帖子
- 541
- 積分
- 212 點
- 潛水值
- 13707 米
| - Sub test()
- Dim i As Long, j As Integer, k As Integer
- Dim lastRow As Long
- lastRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
-
- For i = 2 To lastRow Step 2
- For j = 1 To 256
- If Cells(i, j) <> "" Then
- For k = 1 To 256
- If Cells(i - 1, k) = "" Then
- Cells(i - 1, k) = Cells(i, j)
- Cells(i, j) = ""
- Exit For
- End If
- Next k
- Else
- Exit For
- End If
- Next j
- Next i
- lastRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
- Dim m As Integer
- m = lastRow
- While m > 1
- If Cells(m, 1) = "" Then
- Rows(m).Select
- Selection.Delete Shift:=xlUp
- m = m - 1
- Else
- m = m - 1
- End If
- Wend
- End Sub
複製代碼 試試看這段VBA程式!... |
|