Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
Use concatenated text as name in formulas | Excel Worksheet Functions | |||
Populating a combobox within a form with concatenated data | Excel Programming | |||
populating a cell with text w/ line breaks | Excel Programming |