Do-Until Loop Not Recognizing Range Values
<p>I am trying to get the do-until loop that I have in my code to recognize a date (Date is in format <code>M/DD/YY HH:MM</code>) that adds a single minute to it each time around the loop and then terminate when that value is equal to a second, unchanging value. Here is what I have:</p>

<pre><code>Do
    Range("A9").Select
    Selection.Copy
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("B1").Select
    Application.CutCopyMode = False
    ActiveCell.FormulaR1C1 = "=R1C1+R1C72"
    Range("B1").Select
    Selection.Copy
    Range("A9").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("A9").Select
Loop Until ActiveCell.value = Range("RC74").value
</code></pre>

<p><a href="http://i.stack.imgur.com/ucQvY.png" rel="nofollow">This is a photo of what my sheet looks like with the data removed in the middle.</a></p>

<p>The two cells being compared were BW9 and A9. Sorry I wasnt very specific. The specialty pasting was to prevent a glitch with a third party software that is also being used.</p>