array help[resolved]

[Fragment]

ok this might be confusing to some but ill try to explain it the best that i can.

i have an array, if something is found in the array that i don't want, is there a way for me to ignore it, but continue the array?

if i put exit sub it totally halts the whole array.

any ideas? thanks!

[BruceG]

I'll have to make assumptions here - I am assuming you are looping thru an array, maybe loading up a listbox or something. But if you come across an item in the array that you DON'T want in the listbox or whatever, you want to ignore it and continue on. If this is the case, you can use code like this:

For X = LBound(MyArray) To UBound(MyArray)
    If MyArray(X) = "JUNK" Then
        ' do nothing
    Else
        ' use MyArray(X) as required, for example:
        List1.AddItem MyArray(X)
    End If
Next

[Fragment]

o ahahaha ya, that way works too .

jeez i'm dumb. thanks

[dglienna]

you could also use an EXIT FOR statement.

Add [Resolved] to the subject of the first post to close it.

[BruceG]

Fragment - glad to help.
dglienna - Exit For would cause him the same problem that he wrote about - it would cease processing of the array ...

[dglienna]

oops. meant EXIT IF. didn't see his code, just wanted to explain a few options.

[BruceG]

David -
Hate to beat a dead horse, but "Exit If" does not exist ...

[dglienna]

oops. ignore that one.

[Bruce Fox]

Now you understand the If structure, you could take BruceG's example to the next level like:

For X = LBound(MyArray) To UBound(MyArray)
    If MyArray(X) <> "JUNK" Then List1.AddItem MyArray(X)
Next

Bruce.