Do you have the Sequence() worksheet function on your computer? This gives you the possibility to do this without VBA:
Sequence()
Explanation of the parameters:
C2-B2+1