大年夜还搞?
- Sub tt()
- arr = Range("r2:y7")
- Dim brr(1 To 99)
- For i = 1 To UBound(arr)
- If arr(i, 1) = "" Then arr(i, 1) = arr(i - 1, 1)
- For j = 2 To UBound(arr, 2)
- If arr(i, j) > 0 Then brr(arr(i, j)) = arr(i, 1)
- Next
- Next
-
- arr = Range("c2:i23")
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) > 0 Then arr(i, j) = brr(arr(i, j))
- Next
- Next
- Range("j2:p23") = arr
- End Sub
复制代码 |