F
Flamikey
I got this to work using the Index function. The way I got around th
volatile function is to turn off Autocalc. The deal button runs
macro that just does F9, The HIT, STAND, DOUBLE, and SPLIT buttons pu
a H,S,D,or X in another cell. I then Inserted a check button tha
copies as values the random generated hand, performs a VLOOKUP to chec
the Proper play for the hand, compares it to the cell the HIT< STAND
DOUBLE and SPLIT macros point to, and then another cell does an I
statement if the Player Choice matches the Correct play of the VLOOKUP
conditionally Formatted, and returns either "CORRECT PLAY", or state
what the correct play was.
One question - I had a diffiult time generating all of the possibl
hands. I used OFFSET extensively BUT what is the easiest way t
generate all of the possible combinations from three sets of cards
through Ace? The tool just checks the initial play i.e. shows th
dealers card and the players first two cards and evaluates th
decision, thus the check table needed all combinations of 3 cards.
Thanks
volatile function is to turn off Autocalc. The deal button runs
macro that just does F9, The HIT, STAND, DOUBLE, and SPLIT buttons pu
a H,S,D,or X in another cell. I then Inserted a check button tha
copies as values the random generated hand, performs a VLOOKUP to chec
the Proper play for the hand, compares it to the cell the HIT< STAND
DOUBLE and SPLIT macros point to, and then another cell does an I
statement if the Player Choice matches the Correct play of the VLOOKUP
conditionally Formatted, and returns either "CORRECT PLAY", or state
what the correct play was.
One question - I had a diffiult time generating all of the possibl
hands. I used OFFSET extensively BUT what is the easiest way t
generate all of the possible combinations from three sets of cards
through Ace? The tool just checks the initial play i.e. shows th
dealers card and the players first two cards and evaluates th
decision, thus the check table needed all combinations of 3 cards.
Thanks