VBA: All combinations that sum between two numbers - too much processing blows it up

Hi,

Thanks much in advance for reading. It's really not an overly confusing concept, and I've tried to lay it out as simply as possible!

I have some VBA code (not my own) that successfully returns combination sums between a defined range. A quick summary of what that even means, then my issue.

Example: my range is 5 to 10. My number list is 1, 1, 3, 4, 9.

VBA would return strings of 1,1,3 (sum of 5); 1,1,3,4 (sum of 9); 1,1,4 (sum of 6), and so on and so forth. Literally every unique combination that sums between 5 -10. It returns the string in a cell, moving down a row for every string. Lots of rows usually, I'm sure you can imagine.

Hopefully that's simple enough to track.

My problem is that I want to LIMIT the length of the strings it returns. I only want strings with 1-3 numbers included. So in my above example, the 1,1,3,4 (sum of 9) would preferably not return. Without this limitation, when my number lists get longer, Excel explodes due to having so many qualifying strings to return. I want to reduce the processing required - and only need the data from the smaller 1-3 number strings anyways.

Any suggestions? I wish I was more familiar with VBA, and I've wasted a lot of time already trying to work it out myself as a layman..

My main thought so far is adding a 3rd If statement in the 2nd paragraph of code that somehow accomplishes this.

Tried uploading an example sheet but couldn't get it below 1MB for the life of me..

Thanks

Please Login or Register  to view this content.

add this "And Len(currentset) <= 6" in the last line here below .
6 is 3 digits and 3 commas

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...ws-up.1236547/)

crosspost: https://www.mrexcel.com/board/thread...ws-up.1236547/

Rule 03: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

for example, count the number of commas like this = max 3 sets of numbers
Len(currentset) - Len(Replace(currentset, ",", "")) <= 3