See what values have stored in my array

[Vagelisr]

Hi to all

I try to see what values has stored in my array
I use this code

Please Login or Register  to view this content.

but in msgbox i get runtime error 9

Why??

[Norie]

An array populated from a range has 2 dimensions, try this.
[code

Please Login or Register  to view this content.

PS When posting code can you please use CODE tags?

[Vagelisr]

Thanks for your answer Norie and sorry for the Code Tags

I want to fill an array from cell 1,1 to cell 1,4
how can i do this in 1 dimension array??

Thanks

[Norie]

Do you really need a one-dimensional array?

It is possible but it would require extra work/code.

[Vagelisr]

Yes Only one dimension array.

I really appreciate this Norie

[Norie]

How are you going to use the one-dimensional array?

[Vagelisr]

In a loop
In the array i will store only the values of the columns....

[Vagelisr]

Finally i use this code and work OK

Please Login or Register  to view this content.

[Marc L]

Hi !

Please Login or Register  to view this content.

As you can proceed the same way for an array variable …

Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !