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