|
- Sub lqxs()
- Dim Arr, i&, r%, Arr1()
- Sheet1.Activate
- Myr = [a65536].End(xlUp).Row
- Arr = Range("a4:h" & Myr)
- For i = 1 To UBound(Arr)
- If Arr(i, 1) = "" Then
- r = r + 1
- ReDim Preserve Arr1(1 To r)
- Arr1(r) = i
- End If
- Next
- For i = 1 To r
- Cells(Arr1(i) + 4, 1) = i
- Cells(Arr1(i) + 4, 1).NumberFormatLocal = "[DBNum1][$-804]G/通用格式"
- Next
- End Sub
复制代码 |
|