Testing to see if an array has been initialised

[Ray]

Here's the code example...

Dim myArray() as string

later I will redim the array in a for/next or a Do/While Loop

x = ubound(myArray) +1 <<< causes error 9 if no elements exist
already!
redim Preserve myArray(x)

Here's the question... how do I test the array to see if it was already
initialised without trapping Error 9 (array not initialised)?
I have tried IsArray(myArray) and that returns TRUE and I have tried a whole
bunch of others IsEmpty etc etc

Any help appreciated

Ray

[Rick Rothstein]

I just posted answer to this same question in another newsgroup. Please
consider the following...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups. This is
called Multiposting and it's BAD. Replies made in one group will not be
visible in the other groups, which may cause multiple people to respond to
your question with the same answer because they didn't know someone else had
already done it. This is a waste of time.

If you MUST post your message to multiple groups, post a single message and
select all the groups (or type their names manually, separated by commas) in
which you want it to be seen. This is called Crossposting and when used
properly it is GOOD."

Rick - MVP
"Ray" <ne********@quitealright.com> wrote in message
news:Hl*****************@news.indigo.ie...

Here's the code example...

Dim myArray() as string

later I will redim the array in a for/next or a Do/While Loop

x = ubound(myArray) +1 <<< causes error 9 if no elements exist
already!
redim Preserve myArray(x)

Here's the question... how do I test the array to see if it was already
initialised without trapping Error 9 (array not initialised)?
I have tried IsArray(myArray) and that returns TRUE and I have tried a whole bunch of others IsEmpty etc etc

Any help appreciated

Ray