Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP!!
need to add cell A1 to cell B1 and have the total reside in B1
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|