Named array value in a string variable
MsgBox ActiveSheet.Evaluate(ActiveWorkbook.Names("test"). RefersTo)(2)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"cubbybear3" wrote in message
oups.com...
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
|