Share
ReportHi all,
Im trying to pass a List/Array as a function input to an excel macro from P.A.D. For some reason, the List/Array is not being accepted as a function input. However, specifying the list elements by index, i.e List[0], List[0] allows me to pass in the values but this is obviously not ideal.
For reference, I have left the VBA function parameters as variant and can easily pass arrays between functions in excel but passing Lists/Arrays from P.A.D -> excel fails.
Can anyone give a man a dig out ?
Categories:
All responses (
Answers (
430
