Insert variable value into cell with text VBA

Question

I'm trying to insert the number contained by the variable Row4Num -1 into the Active Cell, along with some text, but I can't quite figure out the syntax. Any help would be greatly appreciated-- Thanks!

      Range("I7").Value = "=""Teams:  & "" Row4Num - 1"

Scott Craner · Accepted Answer · 2016-07-14 16:57:24Z

9

This:

Range("I7").Value = "Teams:  " & Row4Num - 1

When using VBA variables in a String they must be outside the "" and concatenated with &. Everything inside the quotes will be treated as a text string.

edited Jul 14, 2016 at 16:57

answered Jul 14, 2016 at 16:23

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

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

1 Comment

Scott Craner Over a year ago

@reggie86 glad to help. Please mark as correct by clicking the check mark by the answer.

Collectives™ on Stack Overflow

Insert variable value into cell with text VBA

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related