I, along with some help from others who know a lot more about Excel than I
do, have created a batch of forms using Excel and
VB code. We have a bug that
none of us can figure out.
There is a formula in a cell that takes the value of another cell on a
different tab (a dollar amount) and raises that amount to the next $500
{=IF('Cost Est'!G76=0,0,'Cost Est'!G76-MOD('Cost Est'!G76,500)+500}. The
problem is, sometimes that formula is over-written with a value. Therefore,
if changes are made to the €śCost Est€ť sheet, the changes are not reflected in
the cell. This doesnt happen every time and we cant seem to figure out what
is making it happen.
We dont believe that this is occurring because of any code because it has
happened even when the code is disabled. We have searched the sheet and the
code to see if we can find anything that might over-write a cells formula
and have been unsuccessful.
If anyone has any ideas, please let me know. Id be glad to send you the
forms if that will help. (There is nothing confidential involved.) Also,
please note that we are using a very old version (2000) of Microsoft. What
can I say, were a State government agency and a little behind the times.