|
- Sub 双排顺调()
- Dim x%, y%, arr, i%, j%, n%, k%, br
- Dim sh As Worksheet
- Set sh = Worksheets("排座")
- arr = sh.[c6:j11]
- ReDim br(1 To UBound(arr), 1 To UBound(arr, 2))
- For j = 1 To UBound(arr, 2) Step 2
- n = n + 1: k = n Mod 2
- For i = 1 To UBound(arr)
-
- If k = 1 And i = 1 Then
- x = i: y = j + 2
- br(x, y) = arr(i, j): br(x, y + 1) = arr(i, j + 1)
- Else
- If k = 1 And i > 1 Then
- x = i - 1: y = j
- br(x, y) = arr(i, j): br(x, y + 1) = arr(i, j + 1)
- End If
- End If
-
- If k = 0 And i = UBound(arr) And j = UBound(arr, 2) - 1 Then
- br(UBound(arr), 1) = arr(i, j): br(UBound(arr), 2) = arr(i, j + 1)
- Else
- If k = 0 And i = UBound(arr) Then
- x = i: y = j + 2
- br(x, y) = arr(i, j): br(x, y + 1) = arr(i, j + 1)
- Else
- If k = 0 And i < UBound(arr) Then
- x = i + 1: y = j
- br(x, y) = arr(i, j): br(x, y + 1) = arr(i, j + 1)
- End If
- End If
- End If
- Next
- 'Stop
- Next
- sh.[c6:j11] = br
- sh.[m2] = Now() & "已调整座位!"
- End Sub
复制代码
|
|