Thanks for the reply Charlie. Very interesting. The way youve layed
your cards out has given me a couple of Ideas as well. Not quite the
sane as what I was looking at, but I can see how to improve mine. One
point thats I havnt made clear in my post is that Im trying to
anticipate what the odds will be for whatever cards pops out of the
deck. Eg if player had an ace then gets a 2, the odds would be
different (if only slight) if player gets a 3, or 4 etc. What Im trying
to predict is if the odds will rise or drop given the turn of a
particular card. Or at least the percentage of risers/fallers. I can
sort of do this, but Im looking at ways to speed up the macro. I bought
a couple of books on calculating the odds, thinking there was a way of
doing this with combin in excel, but I havent found it yet. Again
thanks for the time, has given me an idea.
Regards Robert