Comparing a range of cells to another range and returning a specific result if match found

Comparing Values Until Matched.xlsmHi. I have a problem constructing vba code that can compare a range of cells (e.g. "A1:F1") in Sheet 2 with a range of cells (e.g. "A1:F49") in Sheet 1. The values in Sheet 1 are changed constantly (using "Calculate") until the values in one of the rows, in the range ("A1:F49"), match those in Sheet 2 ("A1:F1"). When a match is found, the result (i.e. the number of calculations it took to reach that match) must be shown in cell "G1" of Sheet 2.
If successfull I will then add values in Range ("A2:F2") of Sheet 2 and execute the same code for that range, with the result in cell "G2", and so on,
Please see attached workbook. Any help will be greatly appreciated.
Thank you

Thanks for the reply. By stepping into the code (F8) I can see that it compares the values in Row 1 of Sheet 2 with the values in each row of Sheet1. However, the values in Sheet 1 of my example are not supposed to be static, they can be "calculated" randomly by pressing and holding the F9 key {using RAND() and RANK functions in HIDDEN columns "I" and "J"}. Sheet 1 has deactivated code attached that, when activated, has to execute a "Do, Calculate Until"-code until the values from any row in Sheet 1 matches the values in row 1 of Sheet 2. So the final code has to "calculate" and compare rows of constantly changing values in Sheet 1 with the values in Row 1 of Sheet 2 until an exact match is made (the values won't necessarily be in the same order as in Sheet 2) and count how many times it "calculated" to reach that match. I hope this explains a bit more of what I'm tryng to achieve.

Is there perhaps a way to do the calculation while it is comparing, i.e.
Do Calculate
For...
If...
Else...
End If...
Loop Until MatchFound = True? Instead of the code comparing the two ranges, then doing one calculation and again comparing the 2 ranges, then another calculation and comparing, and so on? The idea being that the "Calculation" part mixes the numbers until the rest of the code "catches" the instance where 1 row in range 1 matches range 2. The "Next i" part should be the code moving on to row 2 on sheet 2 where another range of numbers awaits to be compared.