public array
Thanks Bob,
Will that work in seperate procedures. For example if I was to load the
array, then the code ends. Then later I access the array from the other
sheet? I think I need to do something like this, as I am working with
template sheets that are always different versions of the original, so I
can't directly reference any said sheet.
Thanks
AD108
"Bob Phillips" wrote in message
...
Yes just declare it as a Public variable in a standard code module
Public myArray As Variant
load it as usual
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"AD108" wrote in message
...
Hello,
Is it possible to create an array from a range of values, and store it
for
use by code in another sheet?
Thanks in advance.
--
AD108
|