Assigning to an array from a worksheet

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

Thanks for taking the time to post the solution .
or

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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)