Array Problem -- again!

G

gti_jobert

Hello,

Is there a method to find if array elements have been set? For
example;

ReDim Preserve ary(1 To 3, 1 To 3, 1 To Counter) - sets up array

'@ Deletes array values
i = 6
Do
For j = 1 To 3
ary(UBound(ary, 1), j, i) = ""
ary(UBound(ary, 2), j, i) = ""
ary(UBound(ary, 3), j, i) = ""
Next j
i = i + 1
Loop Until i = 7

When i enter data the counter may only = 3 but my loop for deleting the
array values starts from 6 thus i get a 'Subscript out of range' error
as ary(UBound(ary, 1), j, 6) will not exist - anyone know a method to
state if an array has been set?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error 9 - related to an array - adding delimiters back to a cellvalue 4
How to address elements in variant array? 4
3 dimensional array 2
Need Help Modifying Code Please 3
Deleting Last values in an array 3
Looping data out of array 0
populate array 3
Search an array of sheets for an array of numbers & return count of numbers 11

Top