I have a subprocedure:
argument receives an array. Here is how I am calling the sub:
matchingParts is an array that i am trying to give to the send_email function.
I do a test and use the Ubound() function to check the upper bound of the array before putting it into the subprocedure and it shows that there are indeed items in the array. When I check the ubound() value of the array parts in the subprocedure, I get 0 as the upper bound. So suddenly all the elements in my array are removed just by passing the array.
What is going on and how can i pass the array?