Add to Current Cell Value in Microsoft Excel
I often see someone asking if they can, for instance, type a value into A1
and have it add to the value already in A1.
Yes, it's possible, but not without the help of a macro. However, this is a
really bad method of doing any kind of work in Excel. For one thing, it doesn't
provide you with any kind of history. What if you type 12 when you meant to type
21? You have no way of knowing what you just typed because the value in the cell
is now the new value.
Use a macro if you must, but I encourage you to find another method.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved