I have these set of zip code ranges in my excel sheet and I would like to build a code that expands these number ranges into new rows by the simple press of a macro and for it to recognize the numbers after the comma whether they are single numbers or a new range. Any help is appreciated. I also plan to add more ranges so it would need to be looped please.
[/IMG]
![2i9rnmf.png](/board/proxy.php?image=http%3A%2F%2F%5BIMG%5Dhttp%3A%2F%2Fi63.tinypic.com%2F2i9rnmf.png&hash=4564db6b51a0bbb66d4bdef8dcf57068)