|
测试一下- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count = 1 Then
- If Application.IsNumber(Target) And Application.IsNumber(Target(0, 1)) Then
- s = "012345678901234567"
- s0 = Mid(s, InStr(s, Target(0, 1)), 5)
- If InStr(s0, Target) Then x = 44: y = 43 Else x = 43: y = 44
-
- For i = 1 To 5
- Cells(i, x) = Mid(Mid(s, InStr(s, Target), 5), i, 1)
- Cells(i, y) = Mid(Mid(s, InStr(6, s, Target) - 5, 5), i, 1)
- Next
- End If
-
- End If
- End Sub
复制代码
提取左右段数据.rar
(16.7 KB, 下载次数: 5)
|
|