I have a visual basic function with a ParamArray output, and I want that output to be available to another function, without having to put it on a worksheet just to pick it into that second function. Is there a way to transfer arrays between functions in visual basic? Thanks in advance for your response.
I have a function that makes a ParamArray Array( , , ).I know I can dump that to a worksheet, then pick it up again into another function, but I don't want to clutter the worksheet this. Could another Function in VBA have this array passed directly into it?
SteveNeedsSheetNames
2010-04-29 00:01:31
@SteveNeedsSheetNames Please show some simple code. Your function signature and what it returns. ParamArray is a keyword used in the parameter list of a function. Inside the function You get an array of variants. I'm not sure what You mean that Your function produces ParamArray.
Maciej Hehl
2010-04-29 14:36:52