
More Versatile Array Parameters
You can write a single procedure that accepts any type of array as an argument by using a variantparameter. Within the procedure, address the array using the usual syntax: ‘ return the number of itemsFunction ItemCount(anArray As Variant) _ As LongItemCount = UBound(anArray) – _ LBound(anArray) + 1’ the first