|
楼主 |
发表于 2015-2-3 16:11
|
显示全部楼层
- Sub tt3()
- xlen = 7 '数字自设
- With ActiveSheet
- r = .Cells(.Rows.Count, 4).End(3).Row
- .Range("s3:s" & r).Clear
- arr = .Range("d3:s" & r)
- For i = 1 To UBound(arr)
- x = CStr(arr(i, 1))
- y = arr(i, 15) 'R列
- arr(i, 16) = "'"
- If Len(x) < xlen Then x = Application.WorksheetFunction.Rept("0", xlen - Len(x)) & x
- For j = 1 To Len(x)
- t = Val(Mid(x, j, 1)) - y
- arr(i, 16) = arr(i, 16) & IIf(t >= 0, t, t + 10)
- Next
- Next
- .[s3].Resize(UBound(arr), 1) = Application.Index(arr, , 16)
- End With
- End Sub
复制代码 |
|