List numbers between two values

  • Hi all,

    I'll be buggered if I can sort this one myself; I have two Text boxes on a User Form, say 1 & 2 and when submitted these two values are pasted into two cells within a spreadsheet, what I can't figure out is how to have a list of all values between these values in a column, any ideas?

    I'll I can find is =IF(ROWS($1:1)+$Q$6>$S$6,"",ROWS($1:1)+$A$1) but this is only showing 1-9 and not 1-10.