my Select Case function is not working correctly

**DorothyFan1** · 10-24-2011, 08:35 PM

I have a simple list of items in one column and quantity per item in the other column. I needed to create a custom function that would pick up the quantity per item and automatically assign a percentage discount per item based on the quantity of that item.

Please Login or Register  to view this content.

The function is supposed to pick up by looking at the quantity in the original column and automatically assign a discount based on the quantity for that item. But when I run the function...it's giving me zero for all answers! What am I doing wrong?

**Marcol** · 10-24-2011, 08:46 PM

Please wrap your code in code tags, before the moderators get you...

Click here - Forum rules

3. 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 # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

**Marcol** · 10-25-2011, 07:17 AM

Try this

Please Login or Register  to view this content.

You could easily do this without VBa

Please Login or Register  to view this content.

Hope this helps.

**DorothyFan1** · 10-25-2011, 07:48 AM

Thanks for the tips! I appreciated it. The LOOKUP function was neat to know about but I need this in VBA code because it makes it easier to see the tiers and change the percentages accordingly. The tip about setting the argument as a range was great. I had been trying with setting it as either variant or integer and was getting nowhere.