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 Test for empty array is 'UBound(AName) -1'.

For any newish-bies out the

I just discovered that, at least in this context, the inline test to
determine whether the user passed any arguments or not is:

function MyFunc(ParamArray MyArgs)
if UBound(MyArgs) -1 then
<...
else
MyFunc = "Eh, paisan, you wanna passa me an argument?"
endif