Cell changes by itself

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

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,

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
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Audit mode active in one column only; cannot kill. 2
worksheet cross reference 6
Last Modified By in a cell by user 3
data sort while maintining reference with cell in different worksh 1
Comparing data 1
Excel 2002: changing link formula from absolute to relative 3
Data in cell disappears, reappears by scrolling mouse over cell 3
Paste Values in linked Cells Only 4

Back
Top