Hi,
I have the following piece of code
I have 32 different "Criteria1" each with a different three letter name. Could someone please advise me as to how I would go about writing a for each statement that would enable me to replace the 32 chunks of code with one simple paragraph that would greatly improve the efficiency of my program.
Please Login or Register to view this content.
Many thanks in advance.
One of many ways, just fill in the array:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Worked a charm dude, thank you so much. Could you explain this line to me in a bit more detail:
Please Login or Register to view this content.
The array is going to be referenced by the index number of each string in the array. We use "m" as the numeric variable.
LBound(MyStrings) will return the index number of the first item in the array, this is usually 0 or 1. We could just USE 0 or 1 in this spot, but I'm lazy and don't bother to remember which types of arrays are 0-based and which are 1-based. So LBound to the rescue, does it for us.
UBound(MyStrings) will return the index number of the last item in the array. Since you have 32 items that number is going to be 31 for 0-based arrays, and 32 for 1-based arrays. LBound figures out which is correct so we don't have to.
This translates in the example given into either:
orPlease Login or Register to view this content.
It works fine either way.Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Mate that's amazing stuff thank you so much. Just want to learn as much vba as possible so much to learn so little time....
Pfft... all the time in the world.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks