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 |
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 |