Create VB array from cell set

[timwilks13]

Hi, still on a rapid learning curve with VB in excel. I current have a Macro that uses the following array,

Please Login or Register  to view this content.

However I would rather have the names across a cell range, and the array to get each cell value.

	Name
1	Tim Wilkinson
2	David Brooks
3	Jason Goodwin

So something like,

Please Login or Register  to view this content.

Is this a. possible, b.relatively easy?

Any guidance would be greatly appreciated thankyou.

[StephenR]

You can either just reference the range directly:

Please Login or Register  to view this content.

or transfer the range to an array and then loop through that:

Please Login or Register  to view this content.

[timwilks13]

Thank you very much, i went with your second option in the end, did exactly what i wanted. A quick follow up question however, once the code has run

Please Login or Register  to view this content.

for each `r` in the range, is there a way of using them further down the sub, and call them specifically, for example something like

Please Login or Register  to view this content.

or would i just have to specify each cell individually as B2, B3, B4 etc.

I hope that makes some sort of sense.

[kvsrinivasamurthy]

Since r refers the range B2:B4,

First value of r is Range("B2").offset(0,0)
Second value of r is Range("B2").offset(1,0)
Third value of r is Range("B2").offset(2,0)

[Norie]

If you used Stephen's second option then you should have the values stored in the array v.

Please Login or Register  to view this content.

[jindon]

Something like

Please Login or Register  to view this content.

[timwilks13]

sorry i mis typed and meant i went with Stephens first option. Thank you though, still helpful!