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

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

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

That should work okay, as long as it is the same workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AD108" wrote in message
...
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

Actually it would be different workbooks.
Is there a way to preserve it that way? The source workbook would still be
open.
I could have the code (executed from the destination book) load the array
when the code is running now that I think about it. Do I need to set a
reference between the books? I'm not sure how to do this. Would a
reference become invalid when a book is coppied, as a template is coppied
over and over?

Thanks for your help,


"Bob Phillips" wrote in message
...
That should work okay, as long as it is the same workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AD108" wrote in message
...
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

i have an array with 8 elements. i use it in several modules. would it be
possible to store it as a public array so all modules that use it get it from
one place? then i wouldn't have to edit the array in 3 or 4 different modules
when an element changes.

just wondering

--


Gary


"Bob Phillips" wrote in message
...
That should work okay, as long as it is the same workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AD108" wrote in message
...
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

ended up just putting the entire array routine in a separate sub and calling it.

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i have an array with 8 elements. i use it in several modules. would it be
possible to store it as a public array so all modules that use it get it from
one place? then i wouldn't have to edit the array in 3 or 4 different modules
when an element changes.

just wondering

--


Gary


"Bob Phillips" wrote in message
...
That should work okay, as long as it is the same workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AD108" wrote in message
...
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