How to add a typed value to an existing value in a cell in excel?

Question

1.00/5 (1 vote)

See more:

Excel-2016

When typing a numeric value in a cell that already has a non-zero numeric value, is there a way to add the value to the existing value of the cell instead of overwriting it? For example, if a cell has a value of 4 and I want to add the value of 2 to the existing value and replace the cell's value with the sum of 6, is there a way to do this directly in Excel? It’s trivial in the example, but the larger the value, the more error-prone the in-my-head procedure becomes. I'm looking for a simple keystroke solution, not a formula that references another cell. Nor do I want to reference a VBA macro as that just adds more keystrokes.

What I have tried:

I've tried the keystroke "+2" as an example.

Posted 18-Mar-22 11:57am

Greggo

Updated 18-Mar-22 12:10pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2022-03-18T12:10:00

Trye this:

VBA

Dim wbk as Workbook
Dim wsh As Worksheet

Set wbk = ThisWorkbook 'the workbook which stores the code
Set wsh = wbk.Worksheets("Sheet 1") 'here you store your data
wsh.Range("A1") = wsh.Range("A1") + 2

If you want to change values in a range of cells, you need to loop through that collection of cells.

VBA

Dim i As Integer 
For i = 1 To 10
  wsh.Range("A" & i) = wsh.Range("A" & i) + 2
Next

For further details, please see: Excel Visual Basic for Applications (VBA) reference | Microsoft Docs[^]

Good luck!