View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kalpesh[_2_] Kalpesh[_2_] is offline
external usenet poster
 
Posts: 15
Default Passing ParamArray to another function converts it to TWOdimensions.

Hi,

When you call Func, you would be passing in argument with comma
seperated values.
e.g. Func(1,2,3,4)

ParamArray is intended for variable number of arguments, which will be
treated as array internally (when inside method)
In case of subfunc, you are passing only 1 argument (which is an array
as converted by func)

Looking at the code, you are passing the array entirely to SubFunc.
So, subfunc will create an array & store your array (as you passed it
to Func) - in 0th element

HTH
Kalpesh