Set NextCard = TheDeck.Range("A" & NumberCardInDeck + 1)
Set HitLocation = TheTable.Range("H" & (NumberCardInHand + 23))
Do until NumberCardinHand = 2
HitLocation.value = NextCard.value
NumberCardinHand = NumberCardInHand + 1
NumberCardInDeck = NumberCardInDeck + 1
There is more code around this but this is the applicable part. This code Works perfect for the first iteration of the loop But t holds the original value of "NextCard" + "HitLocation" indefinitely and doesnt update them if the values they are dependent on change. is that normal and are there any workarounds?