Formula or macro to list all numbers between two numbers

[clarion419]

Good afternoon. I am looking for either a formula or VBA that will list all numbers between two numbers in different cells. Example: number 1 is in cell A1 and number 10 is in cell A11. I would like to fill in the numbers 2 through 9 in the cells in between A1 and A11. I am using the list function in data validation, so the begin and end numbers will change based on what numbers are chosen from cell A1 and cell B1. I have attached an example.


Thank you

[Pete_UK]

You can put this formula in A2:

=IF(ROWS($1:1)+$A$1>$B$1,"",ROWS($1:1)+$A$1)

then copy down as far as you like.

Hope this helps.

Pete

[clarion419]

Outstanding, thank you sir.