LinkBack URL
About LinkBacks
I have code that looks at thousands of lines, but because there are so many IF statements, it takes a long time to process one line. Anyway I can consolidate?
Please Login or Register to view this content.
I have code that looks at thousands of lines, but because there are so many IF statements, it takes a long time to process one line. Anyway I can consolidate?
Please Login or Register to view this content.
A simple way to speed this up would be to change the End If/If sequences to ElseIf. That way the If tests will stop executing on the the first match. If your data has lots of "Others" then put that test first.
Bob
Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.
thesolution,
Give this a try:
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Tiger: I just attempted to try your method. Everything is coming up as "other". Do you think the compare function is looking to see if all the items in the string match one data point? That would explain why everything is classified as "other".
Blane: Trying your method now...
thesolution,
Attached is an example workbook based on the criteria you described. It contains a button labelled "Classify Items" which is assigned to this macro:
Please Login or Register to view this content.
When I run it, it provides the intended results.
I attached an example of the data I am looking at. I see it works perfectly on yours, so I'm not sure why it's not working when I put the code in.
tiger example.xlsm
thesolution,
Attached is amodified version of your posted workbook. Altered the code to suit. It now provides expected results:
Please Login or Register to view this content.
Wow thank you so much! It works perfectly now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks