Create a looping macro that stops at pre determined row?

Hi!


I am in need of some help figuring out how to loop this process. The macro is built to fetch poker hand histories and paste them one at a time to let my formulas extract the info I want. Which then is stored on a different sheet. The formulas are working from a specified range of cells that each individual hand has to be pasted to.

In short the code below does exactly that, it selects the next hand data, copies it and then deletes the data to bring up next hand from under it.

So the trick now is that I want to loop this process so I dont have to click a button for each hand since there can be upwards to 10k hands to processs. I figured I could have a predetermined range where I can paste hands, so as to not run to many at a single go.


I have looked at the do until function but I dont really understand how to apply it to my case?

Please Login or Register  to view this content.

Thanks for the reply but that wont work as cells will be empty sometimes as the eport file adds a couple of emty rows to each hand.


So I got the looping part to work ok but when I run it in the main sheet it freezes up. It seems to slow down dramatically once the text is copied into working formulas. In my test sheet I ran the loop of moving up hands over a good 300+ hands and it worked flawlessly.

In the main sheet it cant process two hands with the loop but without the loop and me clicking a macro button it works. So my guess is that the amount of formulas are to blame? Even when I copy in a sample manually it definietly slows down Excel notieably for a second before all the formulas updates.




This is more or less the entire code I want to run. The part inside the '''''' lines is code for storing the values that are extracted from the hands. I uploaded the sheet with the code without the storing part. (I havent tried the code with this part when I go through it manually)



The workbook is kind of big and I could separate it if that might help?


Or if any one have a good idea how I can incorporate what the formulas are doing into a complete macro?

Please Login or Register  to view this content.

So I actually got everything to work now!! I had forgotten to replace "Sheet1" with my sheet name....a good thing I dont need to be good at this to put food on the table.

I tried a run with 20 hands and it took pretty dead on 1min, so in one hour it would complete 1200 hands. This would be kind of a PITA and I am looking for ways to speed everything up a bit?


One thing that seems to add alot of steps is my custom function for extracting dollar sums. If I manually go through the code it has to run that function multiple times (guessing for each cell that is applicable).

Please Login or Register  to view this content.