Sub test()
Dim arr(), rng As Range
Set rng = Selection
[z1:z5].ClearContents
If rng.Count = 1 Then
If Len(rng) Then
If rng >= 0 And rng <= 9 Then
arr = [{2,2,2,1,2,0,3,4,5,5;3,3,3,3,3,3,4,5,6,6;5,5,5,4,5,4,6,6,7,7;8,7,8,6,6,8,7,7,8,8;9,"",9,8,"",9,8,8,9,9}]
[z1:z5] = Application.Index(arr, 0, rng + 1)
End If
End If
End If
End Sub
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