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.
Last edited by dohara; 04-28-2014 at 10:07 PM.
Try something like this...
NOTE: varZip is a Range type object if you want to declare it as a Range instead of VariantPlease Login or Register to view this content.
Last edited by AlphaFrog; 04-28-2014 at 06:52 PM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
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.
Last edited by dohara; 04-28-2014 at 10:06 PM.
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
Which is not like the code I suggested.Please Login or Register to view this content.
Please Login or Register to view this content.
You can't use multiple variables in select case unless you use the select case true construct as shown by alpha frog.
Tom
I realize it is not exactly what you wrote as I had to edit it. I am having the same issue. I am sure you can see what I need it to do. What is the issue?
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.
Perfect! It worked. I cam up with one that was a lot more work, complicated and a pain in the rear. I'm going to stick with yours! Thank you very much!!!!!!!
If you would by chance take a look at my other thread to see if you can help point me in a direction. Thanks.
http://www.excelforum.com/excel-prog...roup-noob.html
Also, here is what I did on my own before you got yours to work, just so you can see how much you helped me out.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks