Forum Discussion
VBA Object Variable
I keep Having errors with the below code Public TheDeck As Worksheet Public TheTable As Worksheet Public NextCard as Range Public Hitlocation as Range Public NumberCardInhand as Interger Public...
You'd have to move the lines
Set NextCard = TheDeck.Range("A" & NumberCardInDeck + 1)
Set HitLocation = TheTable.Range("H" & (NumberCardInHand + 23))
inside the loop.