|
本帖最后由 林木水123 于 2023-9-11 09:38 编辑
- Sub 林木水demo()
- Dim i As Integer, h As Integer, arr, sr
- h = Cells(Rows.Count, "b").End(xlUp).Row
- arr = Range("b3:b" & h)
- For i = 1 To UBound(arr)
- sr = ""
- For j = 1 To 15
- If VBA.IsNumeric(Mid(arr(i, 1), j, 1)) Then
- Range("C2").Offset(i, j - 1) = Val(Mid(arr(i, 1), j, 1))
- Else
- Range("C2").Offset(i, j - 1) = ""
- End If
- sr = sr & Range("C2").Offset(i, j - 1).Value
- Next
- Range("R" & i + 2) = "'" & VBA.Hex(Val(sr))
- Next
- End Sub
复制代码 |
|