Array Empty After Sub Called

  • Thread starter Thread starter ExcelMonkey
  • Start date Start date
E

ExcelMonkey

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
 
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.
 
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.
 
Back
Top