Greetings,

This is a strange one!

I place an IF formula in a cell it works perfectly. I place it into a
different column and all of a sudden I get the result and the formula
has vanished. There were IF formulas already in this column but when
I modified them they also disappeared, leaving only the result behind.
I even tried changing the contents of the cell it was looking to, but
the result was fixed!

What kind of setting could do this kind of weirdness on only one
column????

Any possibilities come to mind?

TIA

-Minitman

I would expect that your column is formatted as text.

Though you've not described which works perfectly,
you might give examples of what you are doing.

"Minitman" wrote in message ...
Greetings,

This is a strange one!

I place an IF formula in a cell it works perfectly. I place it into a
different column and all of a sudden I get the result and the formula
has vanished. There were IF formulas already in this column but when
I modified them they also disappeared, leaving only the result behind.
I even tried changing the contents of the cell it was looking to, but
the result was fixed!

What kind of setting could do this kind of weirdness on only one
column????

Any possibilities come to mind?

TIA

-Minitman

Right-click on the sheet tab and "View Code".

Sounds like you have a change_event on that one column doing the deed.

Gord Dibben Excel MVP

On Mon, 25 Oct 2004 18:24:27 -0500, Minitman wrote:

Greetings,

This is a strange one!

I place an IF formula in a cell it works perfectly. I place it into a
different column and all of a sudden I get the result and the formula
has vanished. There were IF formulas already in this column but when
I modified them they also disappeared, leaving only the result behind.
I even tried changing the contents of the cell it was looking to, but
the result was fixed!

What kind of setting could do this kind of weirdness on only one
column????

Any possibilities come to mind?

TIA

-Minitman

Hey Gord,

Right on the money. I had a sub to do uppercase on the column next to
this one. That is working fine. Then the big no-no, I inserted a
column and got distracted. So when I changed the formula without
changing the reference in the Worksheet_Change event, as you said, it
went crazy. Changing the reference to the correct column fixed it.

Thank you for the direction.

-Minitman

On Mon, 25 Oct 2004 16:55:51 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

Right-click on the sheet tab and "View Code".

Sounds like you have a change_event on that one column doing the deed.

Gord Dibben Excel MVP

On Mon, 25 Oct 2004 18:24:27 -0500, Minitman wrote:

Greetings,

This is a strange one!

I place an IF formula in a cell it works perfectly. I place it into a
different column and all of a sudden I get the result and the formula
has vanished. There were IF formulas already in this column but when
I modified them they also disappeared, leaving only the result behind.
I even tried changing the contents of the cell it was looking to, but
the result was fixed!

What kind of setting could do this kind of weirdness on only one
column????

Any possibilities come to mind?

TIA

-Minitman