Returning data from Array is blank

**duckboy1981** · 07-22-2009, 10:34 AM

Hey all,

I have a feeling this is a daft question, but I cannot suss the answer. I have an Array of names that has been created in my code, and I need to output the unique names (name1, name2, name3) in the desired Cell. Using a function I was given on here previously I am able to pass the Array and another Array containg the unique values is created, but I cannot for the life of me work out how the Array is passed back so that I can extract the info? The way I have here causes no errors, but FeeEarnerTotal is blank.

Any help greatly appricated.
Thanks.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**romperstomper** · 07-22-2009, 10:38 AM

You can't just dump an array into one cell anyway, but have you tried stepping through the code to see what is happening?

**duckboy1981** · 07-22-2009, 12:02 PM

I get that I can't just do that, I was just trying to get the initial syntax sorted and next I will sort out the output to that cell. I have stepped through the code and all that I get is a blank. No error occurs, and the variable FeeEarnerTotal remains empty through out. I can understand what is going on in the function and see how it can produce an array of unique items, but I just can't figure out how to get the Array out of the function.

Thanks.

**romperstomper** · 07-22-2009, 12:08 PM

The function returns the array in this line:

Please Login or Register  to view this content.

when stepping through you should be able to check what is assigned to UniqueItems in that line.

**duckboy1981** · 07-23-2009, 05:00 AM

Sorted it. I had a problem a bit further up which meant the Array being passed to the function was actually empty, hence why whatever I tried failed!

Thanks.