Hi, I hoping somebody may have worked, or may have an idea on how to
work on this idea. Not expecting an answer but though Id throw the
question out here.
Ok. Im dealind cards. The games baccarat. All Im doing is if the banker
has a 3 (could be any card though) and te player has a 4 (again
anycard really), is with excel dealing all possibilities for the player
to go on and win. In a1 I put players card, b1 = bankers card. So a2
starts 4A, B2 = 3A. Then can a2 beat b2 yes/no. Then b2 = 32, question,
33 question etc al the way to 3kk (max 3 cards). then a2 changes to 42
and it all starts again. As you can imagine this can take a good 20
secs to run on low cards. I realise its a difficult question to ask but
can this be speeeded up. Im thinking that rather than adding the cards
to a range before asking the question Id put them into an array. At the
momment I deal cards one at a time because it alternates player/dealer
upto 3 cards. Im using select case to make the questioning easier, and
ive got screen updating set to false. Any ideas appreciated.
Regards Robert