Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
.....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

It sounds as though the "return" key is also functioning as the F9 key
normally does on selected items.
If your keyboard has an enter key as well as a return key, does it do the
same thing?


"Anthony" wrote:

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

Sorry keyboard only has an 'ENTER' key..if that is what you were asking

"bj" wrote:

It sounds as though the "return" key is also functioning as the F9 key
normally does on selected items.
If your keyboard has an enter key as well as a return key, does it do the
same thing?


"Anthony" wrote:

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

yes that is what I was asking
if you enter using the check mark next to the formula line, what happens?

I hope someone else has a solution, cause if it is not a macro or something
causing the enter key to act different, you may need to regenerate the file.

"Anthony" wrote:

Sorry keyboard only has an 'ENTER' key..if that is what you were asking

"bj" wrote:

It sounds as though the "return" key is also functioning as the F9 key
normally does on selected items.
If your keyboard has an enter key as well as a return key, does it do the
same thing?


"Anthony" wrote:

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

the same as before, ie the result is shown but the formula goes
...aaarrrrgggghhhh !!!!!

"bj" wrote:

yes that is what I was asking
if you enter using the check mark next to the formula line, what happens?

I hope someone else has a solution, cause if it is not a macro or something
causing the enter key to act different, you may need to regenerate the file.

"Anthony" wrote:

Sorry keyboard only has an 'ENTER' key..if that is what you were asking

"bj" wrote:

It sounds as though the "return" key is also functioning as the F9 key
normally does on selected items.
If your keyboard has an enter key as well as a return key, does it do the
same thing?


"Anthony" wrote:

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks

Unfortunately I think your file is corrupted.

"Anthony" wrote:

the same as before, ie the result is shown but the formula goes
..aaarrrrgggghhhh !!!!!

"bj" wrote:

yes that is what I was asking
if you enter using the check mark next to the formula line, what happens?

I hope someone else has a solution, cause if it is not a macro or something
causing the enter key to act different, you may need to regenerate the file.

"Anthony" wrote:

Sorry keyboard only has an 'ENTER' key..if that is what you were asking

"bj" wrote:

It sounds as though the "return" key is also functioning as the F9 key
normally does on selected items.
If your keyboard has an enter key as well as a return key, does it do the
same thing?


"Anthony" wrote:

BJ,
I have lots of cells populated with Formula but they are working fine, its
just when I place a new formula in a new cell.
....and yes I have macros (I'm affraid I have lots !!!)
thanks

"bj" wrote:

Is this happening in any other cell?
do you have any macros?

"Anthony" wrote:

Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks