Stupler,

Without looking at your sheet would it not be possible to have a Macro
replace the formula in that cell with a constant?

--
HTH

Sandy

with @tiscali.co.uk


"stupler" wrote in
message ...

I'm hoping that someone could help me with a problem I have with an
Excel game I'm making.
'This is the spreadsheet I am having problems with'
(http://uk.geocities.com/ueverwondered/DONDExcelHelp.xls). I'm hoping
this will help me in explaining my problem, since I'm pretty new to the
macro side of things.

It doesn't matter too much if you choose to run macros or not. The
problem lays with the cell to the right of the "Dealt at:" text. It
works by getting the number in the cell next to the "Offer:" text. If
the player types "deal" into the cell above the "Dealt At:" cells, the
cell to the right of the "Dealt At:" text will display whats in that
cell.
But if the player plays on, that number to the right of the "Dealt At:"
text will change too, which I'd like to remain at the first number it is
(when the player typed "deal").

Is it a matter of stopping it recalculating or something else?

(The game is'nt finished, by the way! :) )


--
stupler
------------------------------------------------------------------------
stupler's Profile:
http://www.excelforum.com/member.php...o&userid=32884
View this thread: http://www.excelforum.com/showthread...hreadid=526882