HELP!!
 

need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

Hi Duffy

Only possible with code
Is that a option for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Duffy" wrote in message ...
need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

What do you mean "code"?

"Ron de Bruin" wrote:

Hi Duffy

Only possible with code
Is that a option for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Duffy" wrote in message ...
need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

Hi Ron
What do you mean by codes?
Thanks

"Duffy" wrote:

What do you mean "code"?

"Ron de Bruin" wrote:

Hi Duffy

Only possible with code
Is that a option for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Duffy" wrote in message ...
need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

Cells can't normally both contain a value and a formula. Typically, you
would enter in cell C1 =A1+B1

But you want to enter in B1 =B1+A1

The only way to do that is with VBA code, not normal Excel functions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Duffy" wrote:

Hi Ron
What do you mean by codes?
Thanks

"Duffy" wrote:

What do you mean "code"?

"Ron de Bruin" wrote:

Hi Duffy

Only possible with code
Is that a option for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Duffy" wrote in message ...
need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

VBA code line looks like this then

Range("B1").Value = Range("B1").Value + Range("A1").Value


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave F" wrote in message ...
Cells can't normally both contain a value and a formula. Typically, you
would enter in cell C1 =A1+B1

But you want to enter in B1 =B1+A1

The only way to do that is with VBA code, not normal Excel functions.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Duffy" wrote:

Hi Ron
What do you mean by codes?
Thanks

"Duffy" wrote:

What do you mean "code"?

"Ron de Bruin" wrote:

Hi Duffy

Only possible with code
Is that a option for you ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Duffy" wrote in message ...
need to add cell A1 to cell B1 and have the total reside in B1

HELP!!
 

Why do you "need" the total to reside in B1?

This method is very prone to errors which leave no "paper trail" for future
auditing.

You're always better off using a third cell to Sum 2 others.

See this google search result for more info, including code.

http://snipurl.com/1dmfi


Gord Dibben MS Excel MVP

On Wed, 21 Mar 2007 09:55:16 -0700, Duffy
wrote:

need to add cell A1 to cell B1 and have the total reside in B1