- Sub lqxs()
- Dim Arr, i&, j&, Brr, n&
- Sheet1.Activate
- Brr = [b3].CurrentRegion
- Arr = [b3].Resize(UBound(Brr), 28)
- For j = 1 To UBound(Arr, 2) Step 9
- For i = 1 To UBound(Arr)
- n = Len(Arr(i, j))
- If n > 1 Then
- lf = Left(Arr(i, j), n - 1)
- Else
- Arr(i, j) = lf & Arr(i, j)
- End If
- Next
- Next
- [b14].Resize(UBound(Brr), 28) = Arr
- End Sub
复制代码 |