Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an Array from a called function within a macro | New Users to Excel | |||
Delete empty array columns | Excel Programming | |||
Is the array empty? | Excel Programming | |||
Is Array Empty | Boolean Answer | Excel Programming | |||
Differentiate between "" and Empty in array elements. | Excel Programming |