Click to See Complete Forum and Search --> : Adding a value to array after GetRows()


webfort
08-29-2008, 07:21 AM
Hi.

I found this code snippnet which is exactly what I want but it doesn't seem to work. can any one help?


dim new_array(ubound(getRowsArray(1),GetRowsArray(2)+1))
for i = 0 to ubound(getRowsArray(1))
new_array(i,0) = GetRowsArray(i,0)
next
for i = 0 to ubound(getRowsArray(2))
new_array(i,1) = GetRowsArray(i,1)
next
for i = 0 to ubound(new_array(3))
new_array(i,2) = "new data for extra element"
next


I get Subscript out of range: 'getRowsArray'
I've also tried changing dim to redim

If any one could help or pointme in the right direction that would be great

Kuriyama
08-29-2008, 08:50 AM
Let's see the getRowsArray function.

If nothing else you could display the uBounds for both dimensions of this array.