Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$BZ$1" And Target >= 4 Then
arr = Range("bx60:bx7261")
x = Target
ReDim brr(1 To UBound(arr), 1 To 1)
For i = UBound(arr) - x + 1 To 1 Step -x
brr(UBound(arr) - n, 1) = arr(i, 1)
n = n + 1
Next
Range("bz60:bz7261") = brr
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address = "$BZ$1" And Target >= 4 Then
arr = Range("bx60:bx7261")
x = Target
ReDim brr(1 To UBound(arr), 1 To 1)
For i = UBound(arr) - x + 1 To 1 Step -x
brr(UBound(arr) - n, 1) = arr(i, 1)
n = n + 1
Next
Range("bz60:bz7261") = brr
End If
End Sub