Array

[nada]

Hi! I am trying to create an array that looks like this:
vtFields = Array(Range("B4").Value, Range("R4").Value)
This works fine but I want the array to contain Range("b4").value to eg Range("CC109").value and then it takes ALOT of time to write the array manually. is there any way of doing this without writing every element in the array? Thanks for any help!

 

[Richard Schollar]

Hi

Use a variant variable, and assign the range to it:

vArray = Range("B4:CC109")

Best regards

Richard

 

[nada]

thanx but i have tried that and it does not work. let me specify what im mean. I have a long list, lets say in column A. I then want to create an array that contains the values of the list in column A. Thus the array needs to have the same dimension as the length of the list. When I try your example the array has 0 dimension and I cannot get anything out of it. thanks for your help but I need some other solution. any help appreciated!

 

[Richard Schollar]

Hi

Make sure you have the variable dimensioned as a variant:

Dim vArray as Variant
vArray = Range("A1:A100") 'assigns all the values in A1:A1000 to a 2 dimensional array with Ubound(vArray,1) of 1000 and Ubound(vArray,2) of 1

Richard