formula switches to value ?!?

M

mark kubicki

what toggle, got switched where ?

if A7 contains the value: "Christopher"
and in B9 I enter: "=A7", it automatically switches the formula to the
resulting value (both in the cell, and in the formula bar; the value of B9
is now not "=A7", but: "Christopher")

thanks in advance,
-mark
 
P

Puppet_Sock

mark said:
what toggle, got switched where ?

if A7 contains the value: "Christopher"
and in B9 I enter: "=A7", it automatically switches the formula to the
resulting value (both in the cell, and in the formula bar; the value of B9
is now not "=A7", but: "Christopher")
Click to expand...

Um. I can't get what you describe to happen in my Excel. Maybe
there is more you can tell me? Does this happen in other cells?
Is there any VBA attached to your app? If you change A7 does
B9 update? If you open a new workbook does it still happen
in the new workbook?
Socks
 
M

mark kubicki

hmmm?
in VBA, i'm replacing a cell formula with text; it is once that code runs
that i see the problem

this is a short version of the code (i suspect the last line is wrong, or
some event needs to be disabled for it to happen...)?

If Range("D" & sglVRow).HasFormula Then
MsgBox Range("D" & sglVRow).Address & " contains a formula "
'code for trouble finding, delete at final
MsgBox Range("D" & sglVRow).Value 'code for troublefinding,
delete at final
Range("D" & sglVRow).Value = "not any more !"
End If
 
D

Dave Peterson

You could have a friendly macro that's "helping".

I'd try this:
close excel
start excel in safe mode
windows start button|run
excel /safe
File|open your workbook

Test it out.

The friendly macro could be trying to ensure that the case is correct (like
using =Proper() in another cell).

If the formula stays put, I'd start looking for macros.
 
M

mark kubicki

definetly when the code runs...
i've change it to read.. but it still acts the same:

If Range("D" & sglVRow).HasFormula Then
Range("D" & sglVRow).ClearContents
Range("D" & sglVRow).Value = "not any more !"
End If
 
Top