Assigning to an array from a worksheet

[JoWales]

Morning All,

I am trying to populate an array with values stored in a column in one of my worksheets. I realise that I could manually type in all the values in VBA but as there are 200+ of them, I would like VBA to do this for me!

Thanks for your help!

Joe

[JoWales]

Got it, thanks anyway! Here's how I'm doing it if anyone's interested in the future:

Please Login or Register  to view this content.

Thanks!

[pike]

Thanks for taking the time to post the solution .
or

Please Login or Register  to view this content.

[JoWales]

Thanks for taking the time to post the solution .
or

Please Login or Register  to view this content.

No Problem

Using your method, how do I input a value from within my array to a cell?

If I use, for example,

Please Login or Register  to view this content.

I get the error message:

"Subscript out of range"


If this needs a new thread then just say and I'll move it.
Thanks for your help

[pike]

Please Login or Register  to view this content.

[JoWales]

Excellent, thanks!

[snb]

Or

Please Login or Register  to view this content.

The values will be in clients(1,1) to clients(n,1)

If you want a 1-dimensional array:

Please Login or Register  to view this content.

The values will be in clients(1) to clients(n)