Ioannis solution for multiple combinations

ricardorebelo

New Member
Joined
Jan 23, 2005
Messages
2
Helloo guys,

I'm new to this forum and have been looking in this forum for what I am about to ask you but I have not find it.

Please forgive me if someone has already posted and answer for this.

I am an accountant and I usualy use VB Macros in Excel to help me with my work. The August 2002 Challenge placed by MrExcel was an answer to my prays becuase it is going to make my life so much easier :)

http://www.mrexcel.com/pc09.shtml

Ioannis solution seems amazing but everytime I run the code (with the numbers provided in the challenge), the computer enters in loops and goes on for several hours until I have to shut the processe down.

I know I am screwing this up somewhere but I'm not sure how.

Is there or could someone give me a step by step rundown on how to create the Macro and the Module with that code and use it (there is code for a module but it seems to just sit there).

Thanks a lot guys. I really appeciate it.

Ricardo
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Welcome to MrExcel -- how many numbers are you asking it to scan for your solution?

Keep in mind that the amount of time it takes grows exponentially here...
 

ricardorebelo

New Member
Joined
Jan 23, 2005
Messages
2
I am trying the exact same numbers given in the challenge, just for test.

Also, I am no sure wich part does the Module code plays in this. There seems to be no connection. That function is never called in the main routine.

And what is the final result going to look like?, I'm not sure about that either.

Thanks,

Ricardo
 

IOANNIS

Board Regular
Joined
Jul 12, 2002
Messages
145
Hi Ricardo Rebelo

What about my Code ?

The macro works fine !!

If You want help .... tell me ......
 

Forum statistics

Threads
1,148,525
Messages
5,747,203
Members
424,068
Latest member
Salim khamis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top