Willow Talk

creating custom function

Posted By:

Email:

Date:

Time:

Comments:

In excel, I have coded a custom function using visual basic. The function contains five variables. To define my function i used the code: "Function Calle(s,t,r,x,i)", however i was not able to input the five variables as a range in the excel sheet. Precisely, when i run the function in the excel sheet by entering =Calle(B1:B5), no value is given. How can i modify my definition of the function to make it applicable to range input? Any idea if this can be done?