permut and combin functions
Hello
I was trying to use the permut and combin functions (which are available in excel) in vba, but i keep on getting the error
"Compile error:
Sub or Function not defined" when using the functions in vba.
is there a library that i need to import in order to get permut and combin to work?
Re: permut and combin functions
I just opened up an new Excel workbook, put =PERMUT(A2,A3) in cell D1, popped some numbers in A2 and A3 and it worked just fine for me.
What version of Excel are you using?
Re: permut and combin functions
Hack :
Hes using VBA to call the functions in Excel.
vb_s:
How are you trying to use them atm?
Edit:
Code:
?application.Evaluate("permut(5,2)")
20
(using the immediates window)
Re: permut and combin functions
Can you post the code you are using to call the functions?
Re: permut and combin functions
thanks for the replies guys
i did
myvalue = permut(5,2)
and it gave the error
"Compile error:
Sub or Function not defined" when using the functions in vba.
hey ecniv, what is the
application.Evaluate command in your code?