Array Empty After Sub Called
 

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

Array Empty After Sub Called
 

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

Array Empty After Sub Called
 

Yeah thats what I thought to but doesn't seem to be the
case. Have reposted with detail.

Thanks for all you help Tom. Been living off every word
for last several days.


-----Original Message-----
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


.