Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nightmare with Arrays
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif nightmare! | Excel Worksheet Functions | |||
PivotTable Nightmare | Excel Discussion (Misc queries) | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
IF Statement nightmare | Excel Discussion (Misc queries) |