Populating a cell with concatenated text...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to enter a combination text/cell value in a cell, but vba won't let
me. It expects the end of the statement. Example: Range("A5").Formula = _
"=Summary of "&Q1&" manual comparison."

.... where Range("Q1") could be "Current" or "MTD".

Any help would be appreciated.

Sam
 
Sam:

Try:

You need to put the text in quotes:

Range("A5").Formula = _
"=""Summary of "" & Q1 & "" manual comparison."""
 
Sam

Need a few more double quotes.

Range("A5").Formula = "=""Summary of "" & B1 & "" manual comparison."""


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CONCATENATING CELL CONTENTS ! 2
Concatenate VBA syntax 0
Last Modified By in a cell by user 3
Replace cell formula with revised text as noted within a cell valu 3
Excel VBA 1
Need macro that concatenates cells with text 7
Naming non-contigent cells with vba 5
populate cells within merge area 5

Back
Top