Changing the arg to use ByVal does not change the result.
I have not looked at your other suggestions.

Take a look at http://www.decisionmodels.com/downlo...AreasBugBypass.
--
http://www.standards.com/; See Howard Kaikow's web site.
"keepitcool" wrote in message
...
Checked your AreasBug.xls too...

the problem you describe is caused by passing an
unqualified reference to the udf you created

would you declare it a range = no problem.
now that you decalre it a variant the activesheet is used
rather then the caller's sheet

You can solve THAT by either changing the calling function To:
k3 to =processvariant((Arrays!$A$1:$D$2, Arrays!$A$3:$D$3))

Or change your function to work byVal rather then byref
Function ProcessVariant(Optional ByVal vntArray as Variant = Nothing)

Bugs? not!


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


keepitcool wrote:


You yell BUG, but's it's your lack of understanding :)