S
Steve
Hi
I did write yesterday but with no real success.
I am trying to put a number of values in an array by looping through some
cells.
I'm having difficulty as I don't know how long the array will be nor can I
sem to add to it.
I have tried the following so far.
A=array() - create an empty array
A(0) = cells(count,1).value
A(1) = cells(count,2).value
etc etc
I have looked at similar code that puts cell information into an array and I
think it's the creation of a blank array that is the problem.
The trouble is that I do not know how big the array is going to be.
Any guidance would be appreciated.
Thanks
Steve
I did write yesterday but with no real success.
I am trying to put a number of values in an array by looping through some
cells.
I'm having difficulty as I don't know how long the array will be nor can I
sem to add to it.
I have tried the following so far.
A=array() - create an empty array
A(0) = cells(count,1).value
A(1) = cells(count,2).value
etc etc
I have looked at similar code that puts cell information into an array and I
think it's the creation of a blank array that is the problem.
The trouble is that I do not know how big the array is going to be.
Any guidance would be appreciated.
Thanks
Steve