Noob: Case select & Statement

I have a case select that I use in another spreadsheet. I am trying to edit it to work for my current one. What I need to do is add an & statement. Meaning if C2 Case Is < 46.1 & D2 Case Is < 6 arrStore(StoreIndex) = "A"

Currently this is what I have

Please Login or Register  to view this content.

Try something like this...

Please Login or Register  to view this content.

NOTE: varZip is a Range type object if you want to declare it as a Range instead of Variant

I tried below, and have an issue. It is stopping at the first case. I like where you were going with it.

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Edit your previous posts and add code tags.


This is the code you edited

Please Login or Register  to view this content.

Which is not like the code I suggested.

Please Login or Register  to view this content.

Thank you for the code tags. Well done.

Try something like this. It's not tested and I don't know if I got all your logic correct, but you should get a sense of the syntax used.

Please Login or Register  to view this content.