All possible combinations speed up code

[YasserKhalil]

Hello everyone
I have this code that calculates all the possible combinations for the sum of specific numbers

Please Login or Register  to view this content.

It is working well but it took about 6 minutes (Is there a way to make it faster?)

Thanks advanced for help

[karedog]

This seems a bit faster :

Please Login or Register  to view this content.

[YasserKhalil]

That's really awesome and fascinating .. Thank you very very much Mr. Karedog for this masterpiece
Best and kind regards

[karedog]

You are welcome, thanks for marking the thread as solved and rep.points.
As a guidance, you must avoid calling WorksheetFunction inside excessive loop, it takes a very big overhead.

Regards

[YasserKhalil]

You are welcome, thanks for marking the thread as solved and rep.points.
As a guidance, you must avoid calling WorksheetFunction inside excessive loop, it takes a very big overhead.

Regards

Thanks a lot for your useful guidance.. You are my savior all the time