If you want the numbers between value in A1 and value in B1 as an array, try:

=ROW(INDIRECT(A1&":"&B1))

This formula does not require array-entering.


Select the cell with above formula and press F2, then F9 and you should see the numbers between 88 and 93 if you have 88 in A1 and 93 in B1.

Thanks for taking the time to respond here. I was messing with that approach for hours last night but I don’t have a very good understanding of how arrays work. When I ran that my results were ={88;89;90;91;92;93}. When I record the process for a Macro it at first seems to work but when I change A1 or B1 to another range it does not work. When I look at the recorded code I am getting this.

Sub Macro1()
Range("C1").Select
ActiveCell.FormulaR1C1 = "88;89;90;91;92;93"
Range("D2").Select
End Sub


I tried changing it this and got an error


Sub Macro1()
Range("C1").Select
ActiveCell.FormulaR1C1 = "ROW(INDIRECT(A1&":"&B1))"
Range("D2").Select
End Sub

This was when I was thinking just a simple formula where there is a A1 +1 loop until the results equal B1 then break loop might be easier but it seems like this is way beyond my capabilities also and the formula is not so simple.