How do I call an Excel Function (COMBIN) from my user created function?
Posted on 2014-12-28
I pass 4 variables to a VBA function, and from them calculate 8 dependent variables from which I need to calculate and pass back to the Excel cell:
FName = ( Combin(n1,n2) * Combin(n3,n4 ) + ( Combin(n5,n6) * Combin(n7,n8 ) )
One by one I can return n1 - n8 and the numbers are correct, but I can't even get constants to work: i.e. FName = Combin(5,3)
Err: (With "Combin" hi-lited): Compile error: Sub or Function not defined
Any help with syntax will be greatly appreciated.