Add value to cell based on another cell

[tomstanley91]

Hi all,

Great forum! Lots of useful advice on here.

I‘m looking for some VBA code to add the value of a cell to another cell.

Essentially, I want to add the output value of cell A4 onto cell C90. So, say for example A4 contains 10, I’m looking to add +10 to C90.

Cell C90 already has numbers in it, so I’m looking to just add the value of A4 onto the end of the end of the existing numbers - keeping what’s in there already (I.e. so C90 will look something like =15+10+10).

One thing to bear in mind is that I need the value of C90 to show the adding of A4.

Is this possible?

Many thanks

Tom

 

[bebo021999]

What actual is in C90:

before: a formula (=15+10) = 25, then after: (=15+10+10) = 35

or

before: text string "=15+10", then after: "=15+10+10"

???

 

[tomstanley91]

Hi there,

Currently C90 contains: =15+10
And after i’d like it to be =15+10+10

(Based on Cell A4 containing 10).

 

[bebo021999]

Maybe:

Range("C90").Value = Range("C90").Formula & "+" & Range("A4").Value

 

[tomstanley91]

Ahh that’s perfect! Thank you so much!