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