Cell changes by itself
 

Hi,

I am trying to assist with a workbook I didn't create. In a particular
column ("CE") when you type a formulae in certain cells (eg CE24) the
formulae from the cell in the row above from column CF (eg CF23) appears in
CF24.

I've searched everywhere and can't see why this is occuring. There are NO
worksheet/book events that may trigger this.

Andrew
070208



--
Andrew

Cell changes by itself
 

Andrew,

Select cell CF24 and look at the formula bar. Is there a formula in this
cell? I'm guessing it is something like =IF(CE24="","",CF23). If that is
the case, delete this formula.

HTH,

Conan




"Andrew" wrote in message
...
Hi,

I am trying to assist with a workbook I didn't create. In a particular
column ("CE") when you type a formulae in certain cells (eg CE24) the
formulae from the cell in the row above from column CF (eg CF23) appears
in
CF24.

I've searched everywhere and can't see why this is occuring. There are NO
worksheet/book events that may trigger this.

Andrew
070208



--
Andrew

Cell changes by itself
 

No, it's not that easy.

I delete the contents of CE24 & CF24 and then type a formula in CE24 and for
some reason a formula appears in cell CF24.

I thank you for your response but there is something going on here.

I've searched all VBA code in the workbook, both modules and sheets but
there is nothing there (eg on_change etc).





--
Andrew


"Andrew" wrote:

Hi,

I am trying to assist with a workbook I didn't create. In a particular
column ("CE") when you type a formulae in certain cells (eg CE24) the
formulae from the cell in the row above from column CF (eg CF23) appears in
CF24.

I've searched everywhere and can't see why this is occuring. There are NO
worksheet/book events that may trigger this.

Andrew
070208



--
Andrew