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
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