Change cell value without chaning formula
 

How can I do it?
Daniel

Change cell value without chaning formula
 

On 31 Jul, 23:52, Daniel wrote:
How can I do it?
Daniel

Daniel,

What do you mean ?

Give an example.

Matthew

Change cell value without chaning formula
 

When I click on the cell with name "total", the formula bar show a formula.
When I click on the formula bar to change it name, the formula is gone !
How can I change the "total" to diferent name? without changing my formula
I think this is excel basic but I don't know
Thanks for your help
Daniel

"Matthew" wrote:

On 31 Jul, 23:52, Daniel wrote:
How can I do it?
Daniel

Daniel,

What do you mean ?

Give an example.

Matthew

Change cell value without chaning formula
 

Change the value in the cell the formula references.

I have in A1 =B1

B1 is qwerty

A1 reads qwerty

Change B1 to asdfgh and A1 will read asdfgh


Gord Dibben MS Excel MVP

On Tue, 31 Jul 2007 15:52:00 -0700, Daniel
wrote:

How can I do it?
Daniel

Change cell value without chaning formula
 

Hazarding a thought here ..

You could be referring to a defined/named range called: "total"

Try clicking Insert Name Define
The options to change defined names are there
eg In the Define Name dialog, select "total", then edit the name within the
"Names in workbook" box to say "Totalled". Click Add. Then re-select "total"
again, click Delete. Click OK to dismiss the dialog.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Daniel" wrote:
When I click on the cell with name "total", the formula bar show a formula.
When I click on the formula bar to change it name, the formula is gone !
How can I change the "total" to diferent name? without changing my formula
I think this is excel basic but I don't know
Thanks for your help
Daniel

Change cell value without chaning formula
 

Could not see "total" in define name?
Daniel

"Max" wrote:

Hazarding a thought here ..

You could be referring to a defined/named range called: "total"

Try clicking Insert Name Define
The options to change defined names are there
eg In the Define Name dialog, select "total", then edit the name within the
"Names in workbook" box to say "Totalled". Click Add. Then re-select "total"
again, click Delete. Click OK to dismiss the dialog.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Daniel" wrote:
When I click on the cell with name "total", the formula bar show a formula.
When I click on the formula bar to change it name, the formula is gone !
How can I change the "total" to diferent name? without changing my formula
I think this is excel basic but I don't know
Thanks for your help
Daniel

Change cell value without chaning formula
 

Then my earlier guess was out.
... and I'm out of further guesses here, sorry.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Daniel" wrote in message
...
Could not see "total" in define name?
Daniel

Change cell value without chaning formula
 

Note that a cell *cannot* contain both a formula & a constant value at the
same time. If you delete/type over the formula with say some text, then of
course the formula's gone. Perhaps you were trying to do that?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---