Sub test()
Dim A(9), B(), rng As Range, i
Set rng = Selection
[z1:z5].ClearContents
If rng.Count = 1 Then
If Len(rng) Then
If rng >= 0 And rng <= 9 Then
A(0) = Array(2, 3, 5, 8, 9)
A(1) = Array(2, 3, 5, 7)
A(2) = Array(2, 3, 5, 8, 9)
A(3) = Array(1, 3, 4, 6, 8)
A(4) = Array(2, 3, 5, 6)
A(5) = Array(0, 3, 4, 8, 9)
A(6) = Array(3, 4, 6, 7, 8)
A(7) = Array(4, 5, 6, 7, 8)
A(8) = Array(5, 6, 7, 8, 9)
A(9) = Array(5, 6, 7, 8, 9)
B = A(rng)
ReDim B(1 To UBound(B) + 1, 1 To 1)
For i = 1 To UBound(B)
B(i, 1) = A(rng)(i - 1)
Next i
[z1].Resize(UBound(B)) = B
End If
End If
End If
End Sub
(, 下载次数: 6)