the first thing that comes to mind is in the sub where it fails, you have a
duplicate name declared. This local variable takes precedence and contains
no data.

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote in message
...
I have a public 1D array.

Public Array1 as Variant

I have loaded it with text strings.

Array1(0) = "Comment"
Array1(1) = "Range"
etc

After loading it, I Debug.Print Array(0) etc and it shows
that the array has text strings in it. I can also search
the array with an application.Index function and return
the strings.

However right after I call a new sub, the array is
empty. This is odd as it was declared as public and I
have other arrays in the same sub with integers which
make their way to the sub that his one is failing in.

Anybody know why this would happen?

Thanks