Adding ranges and values VBA

Question

The first formula is working but the next two formulas are not. Can someone can explain the proper syntax when adding values like this? Like, when to use the ampersand and proper placing of quotations. Thank in advance.

Range("F1").Formula = "=(" & Range("I1").Value * 1000 & ")/1000" Range("D15").Formula = "=(" 1 + Range("D15"").Value * (1 + Range("C15").Value) & )- 1" Range("E15").Formula = "=(" 1 + Range("E15").Value * (1 + Range("C15").Value) & ")- 1"

First thing I notice is an extra quote here Range("D15"").Value — braX
– braX, Commented Oct 3, 2017 at 14:32
The first formula is right, bare in mind that you need to write your formula as a String. And if you write some variable, it should be "string" & variable_calculation + 1 & "string" — danieltakeshi
– danieltakeshi, Commented Oct 3, 2017 at 14:33

braX · Accepted Answer · 2017-10-03 14:34:14Z

3

I'll try to fix it - you are missing ampersands:

Range("F1").Formula = "=(" & Range("I1").Value * 1000 & ")/1000"
Range("D15").Formula = "=(" & 1 + Range("D15").Value * (1 + Range("C15").Value) & ")- 1"
Range("E15").Formula = "=(" & 1 + Range("E15").Value * (1 + Range("C15").Value) & ")- 1"

answered Oct 3, 2017 at 14:34

braX

11.9k5 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding ranges and values VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related