View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] baobob@my-deja.com is offline
external usenet poster
 
Posts: 100
Default Passing ParamArray to another function converts it to TWO dimensions.

If I set watch points for Params and SubParams below, I find that
Params has one dimension but SubParams has TWO:

Function Func(ParamArray Params) as String
... = SubFunc(Params)
End Function

Function SubFunc(ParamArray SubParams) as String
...
End Function

The following (to me) ludicrous kludge fixes the problem, making
SubParams the nice, obedient 1-dim array equivalent to Params that it
should be:

Function Func(ParamArray Params)
... = SubFunc(Params(0))
End Function

What in HELL is this? String theory?

***