Sub cc()
Dim i%, j%, t%, arr, rng()
arr = Sheets("sheet1").Range("b1:j25") '这里的数组区域来是是B2:B25区域.!'
ReDim brr(1 To UBound(arr, 1), 1 To 9) '创建数组'
Sheet1.[n1:v25] = ""
Sheet1.[n1:v25].Interior.ColorIndex = 0
Sheet1.[n1:v25].Font.ColorIndex = 15
Sheet1.[n1:v25].Font.Bold = False
'arr = Range("b2:b" & [b65536].End(3).Row)
j = 1
For t = 1 To UBound(brr, 2)
For i = UBound(arr) To
2 Step -1 '--' 就是这一句,如何让循环从25单元格循环到2单元格!
If arr(i, t) = "" Then
brr(i, t) = j
j = j + 1
Else
brr(i, t) = Right(j - 1, 1)
Cells(i, arr(i, t) + 13).Interior.ColorIndex = 3
Cells(i, arr(i, t) + 13).Font.ColorIndex = 2 ''颜色
Cells(i, arr(i, t) + 13).Font.Bold = True
j = 1
'Exit For
' MsgBox arr(i, t)
End If
Next
j = 1
Next
Sheets("sheet1").[n1].Resize(UBound(brr, 1), UBound(brr, 2)) = brr '这里的N1本来我是想改成N2的!'
End Sub
循环上标和下标问题2.rar
(10.39 KB, 下载次数: 3)