Macro to generate all numbers between two numbers

Hi everyone,

I was able to cobble together a macro from another posting on another site and it works if I only put in one starting and ending number, but if I do more than one it gives me everything between all the numbers. What I want is to be able to put in a starting and ending number on multiple lines and for it to give me the number between the start and end per line. At the bottom of the post is my current code.

For example if I put in the following:

Starting Ending
850 853
900 903


I get the following back:

850
851 This part is what I want
852
853
everything from 853 to 899
900
901
902
903


What I want to get is:

850
851
852
853
900
901
902
903


Then lastly I'm also looking for macro language to output another string where each number is output separated by a comma.


Thoughts? I tried a loop but with no luck.

Please Login or Register  to view this content.

Hi XL2008,

See if this code gives you the numbers separated with commas. This is a User Defined Function (UDF) and see it work in the attached.

Please Login or Register  to view this content.