I have a worksheet that simulates dealing cards, and calculates th
number of times you could expect to get a king, queen or ace.

What I want is to graph the results as the macro runs.
I know I want a loop function, but cant get my head round it!

For information,
The range i want to graph is: A1:A40 and C1:C40 where row 1 has th
header: "queen" and "king" on A and C respectively .

I would like cell P1 to include the number of deals I want to produce
ie: the number of times it should loop.

Any ideas on how I should construct the code - my attempts have bee
unsuccessful Im afraid.

Thanks
Scott

--
scottwilson
-----------------------------------------------------------------------
scottwilsonx's Profile: http://www.excelforum.com/member.php...fo&userid=1112
View this thread: http://www.excelforum.com/showthread.php?threadid=26646