How can I store calculations using a currency exchange rate (stored
in A1 for example) but not have the result change when the exchange
rate is update? I do not want to store each exchange rate variation
in a new location every time it changes.

Normally, exchange rates are transaction-specific, meaning they are
stored in the transaction record under a dedicated field.

Normally, each row is a separate transaction record, meaning each
record will possibly have a different exchange rate entered into its
ExchRate field.

The ExchRate field is used to calc the home (or foreign) amount for
each record.

Thus, if you expect to keep accurate transaction records then you need
to embrace entering the exchange rate for each transaction!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion