|
有一个数据组如图 A行与B行所示。
请问如何能把A行与B行,自动设置成C行与D行一样。
我试了很多次都不行。
下面是一个调试代码,走不通。请高手指点啊?万分感激!
Sub test()
Dim i As Integer, j As Integer
For i = 1 To 15
For j = 1 To 4
If Range("A" & i).Value <> j Then
i = i + 1
Cells(i, "D").Value = j
Else
Cells(i, "D").Value = Cells(i, "A").Value
End If
Next j
Next i
End Sub
- Sub test()
- Dim i As Integer, j As Integer
- For i = 1 To 15
- For j = 1 To 4
- If Range("A" & i).Value <> j Then
- i = i + 1
- Cells(i, "D").Value = j
- Else
- Cells(i, "D").Value = Cells(i, "A").Value
- End If
- Next j
- Next i
- j = 2
- For i = 2 To 15
- If Len(Cells(i, "d")) > 0 Then
- If Cells(i, "d") = Cells(j, "a") Then
- Cells(i, "e") = Cells(j, "b")
- j = j + 1
-
- End If
- End If
- Next
- End Sub
复制代码
|
|