|
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Not Application.Intersect([a3:f3], Target) Is Nothing And Application.WorksheetFunction.CountA([a3:f3]) = 6 Then
- Call jh
- End If
- End Sub
复制代码- Sub jh()
- Dim arr(1 To 1, 1 To 6)
- For i = 1 To 6
- zf = "'0123456789"
- For j = 1 To i
- zf = Replace(zf, Cells(3, j), "")
- Next
- arr(1, i) = zf
- Next
- [a3:f3] = ""
- n = Range("l65536").End(xlUp).Row + 1
- Cells(n, "l").Resize(1, 6) = arr
- End Sub
复制代码 |
|