Populating a cell with concatenated text...
 

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

Populating a cell with concatenated text...
 

Sam:

Try:

You need to put the text in quotes:

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

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Sam" wrote:

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

Populating a cell with concatenated text...
 

Sam

Need a few more double quotes.

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


Gord Dibben MS Excel MVP


On Fri, 23 Feb 2007 16:35:00 -0800, Sam wrote:

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