Array showing "nothing" but i know something is in it

[welchs101]

Hi, I am enclosing an excel file.

I have 3 arrays.
One array reads in col 1 and col2 from sheet "Calc_sheet_dont_delete"
another array reads in col3 and col4 from sheet "Calc_sheet_dont_delete"

Another array compares col1 with col3. If value in col1 is not in col3 then store result in this array......called "active_not_in_combined".

Problem is that when i try to show to the screen the contents of "active_no_in_combined" it has the right "number of entries in array" but all values are "blank".............but this should not be. In another part of the program where i assign values to this array.....the assignment appears to be working.

Not sure whats going on.........very very very confused.

just to be clear.........i dont know why when i try to show to the screen the contents of the array array "active_not_in_combined" ........contents show up as "blank" ie....empty....not sure why?

[welchs101]

ok...figured it out..........

I had this in my code

Please Login or Register  to view this content.

I should have had the following

Please Login or Register  to view this content.

without the preserve array contents seem to get cleared.......