| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using the value of a macro variable in a concatenate formula
I guess NameStr has been defined as a name on the worksheet.
If this is true, use Range(Namestr).value instead HTH -- AP "Simon W" a écrit dans le message de ups.com... thanks for the reply - unfortunately it gives me an 'application defined of object defined error'. The concatenate formula works without " & NameStr & " and NameStr is defined as i can put it into a different cell not as part of the concatenate formula. Very grateful for any suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate Variable Array of Text Cells | Excel Discussion (Misc queries) | |||
| Macro - Formula RC[?] with ? being a variable number | Excel Discussion (Misc queries) | |||
| Concatenate column with variable to set a range | Excel Discussion (Misc queries) | |||
| Macro Sum Formula For a Variable Rang | Excel Programming | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Hybrid Mode
