Probably a userform would be necessary for this. You could apply ranges to buttons (just as an example) and when the user selects a range the code can do whatever to that range.

If you ranges will change, I don't see how the user will be able to select a range they want without actually entering the range. Of course, I may not be understanding you correctly either.