Recent content by Magic200777

I'm trying to pass the function the customer number so the function can "collect" the record(s) in an array that the customers had ordered so the number of elements are unknown. I was hoping to have a variant array that the function can pass back... do I need to do this in a subroutine and have...

I have a problem with a function that is suppose to return an array. I have defined array A() as Variant then populated it based on how many elements are needed. When I try to assign the first element with A(1) = "my text", I get index out of range error. I tried A(0) and get the same...