| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenating text with address reference
Hi,
I am unable to concatenate the word "Total " with a cell address. Here's my script: ActiveCell.Offset(0, 1).Formula = "+Total " & " & " & (ObjectHeadAddress) The result is: +Total & E73 I would like the formula to come out looking like : +"Total "&E73 so that the formulae in the cell is meaningful. Please advice how to get the extra " " marks around the work Total. When I try to put in the extra quotation marks, I get the debug error message. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert ADDRESS() text result to cell reference | Excel Worksheet Functions | |||
| Hyperlink Address and SubAddress not concatenating correctly | Excel Discussion (Misc queries) | |||
| Concatenating a cell address | Excel Worksheet Functions | |||
| Construct address as a reference not "text" | Excel Worksheet Functions | |||
| How can I convert text to reference ? Ex: ISNUMBER(ADDRESS(6;10;2. | Excel Discussion (Misc queries) | |||
Threaded Mode
