Concatenation error with equal sign VBA excel

Question

I have this code where ttlMtrs is an integer < 7000

diffFormula = "=1-(" & ttlMtrs & "/7000)*1200"
Debug.Print diffForumla

I am trying to build a string that will evaluate once printed to a cell in excel. When I Debug.print to check the string I only get blank lines. One time I got long string of garbage characters.

I am trying to figure out what I am misunderstanding in building this string. Any ideas are appreciated.

I honestly couldn't tell you how many times I've recommended Option Explicit this week. — user4039065
– user4039065, Commented Jun 28, 2018 at 13:30

Taylor Raine · Accepted Answer · 2018-06-28 13:27:42Z

2

you have mispelled the variable name in the debug statement

Debug.Print diffForumla

should be

Debug.Print diffFormula

note the changed position of the u

answered Jun 28, 2018 at 13:27

Taylor Raine

5777 silver badges24 bronze badges

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

2 Comments

Bill the Lizard Over a year ago

Using Option Explicit in your module will help you avoid this kind of error.

NoleloN Over a year ago

Thank you, I feel pretty silly. Before it was printing some garbage errors but this is the answer. Thank you.

Vityata · Accepted Answer · 2018-06-28 13:25:35Z

1

Public Sub Test()

    Dim ttlMtrs As String
    Dim diffFormula As String
    diffFormula = "=1-(" & ttlMtrs & "/7000)*1200)"
    Debug.Print diffFormula

End Sub

This should be the result:

=1-(/7000)*1200)

answered Jun 28, 2018 at 13:25

Vityata

43.8k10 gold badges64 silver badges110 bronze badges

1 Comment

user4039065 Over a year ago

uneven bracketing.

Collectives™ on Stack Overflow

Concatenation error with equal sign VBA excel

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related