Disliked{quote} I have attached test result with 4 tabs with diff currency pair. I have tested each of 3 times in a cycle and have same results which are logged in Column C,D,E in Row 1,2,3. you can rerun these pairs within this excel you should get the same result. I am unable to replicate your error. Scenario Question - - you ran on currency pair (AUDUSD) which has 7643 rows. record your result. Run it the second time and record your result and it is same. - you copy paste a new currency pair (EURGBP) which as 7940 rows. record your result. - Now you...Ignored
I will look at the results once I get home . Cannot open a preview in my phone.
I use CountA formula for counting all cells without a blank and extended to the while column. I also Used Rows formula and manually scrolled down to the last row to count the rows.
In the two files I previously attached, they had same number of rows.
Maybe someone else can do his/her test in cycles..
Thanks for checking,