| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named array value in a string variable
As an example, I have a named array "aryXYZ" defined as:
={"abc","456","@#$"} (and yes, I did use Ctrl+Shift+Enter) I can get the second (or for that matter, any) element/entry into a a cell with: =INDEX(aryXYZ,2) What I would like to do is get the value into a string value in a macro without loading a worksheet cell first. Any hints/clues would be nice. Thank you. -pb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying To Append String Variable To Another String Variable | Excel Programming | |||
| how to parse string into array or variable? | Excel Programming | |||
| Passing string as array variable (Pivot VBA) | Excel Discussion (Misc queries) | |||
| setting a range variable equal to the value of a string variable | Excel Programming | |||
| VBA - Convert my variable range array to single cell string | Excel Programming | |||
Threaded Mode
