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