Multiple case statements

How can i use multiple case statements? Or is there any alternative?

My problem is:

I have to give a min. and max range in the workbook. If the user select min as 2 and max as 5 then the function should work within the range 'case 2' and 'case 5' (ie. case 2, 3, 4 & 5) should work.

case 1
function()

case 2
function ()

Case 3
function ()

case 4
function ()

Case 5
function ()

case 6
function ()

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Take notice of what you have been told about reading the Forum Rules, this is the second post that breaks the Rules!