#VALUE! Error and Calling Auxiliary Functions

Hi all,

I have encountered 2 separate problems with my VBA codes. Just to let you know I am just a beginner so these problems may seem trivial. I am using Excel 2013 for all scripts.

1) Here I am writing a code to determine NPV and I can't seem to get the function to work. The script as I have typed them is below:

Please Login or Register  to view this content.

When testing out the code on Excel worksheet I get the error #VALUE!


2) For the second problem I have written 2 auxiliary functions and a main function to call the auxiliary functions. The scripts for all the auxiliary and main functions are below:

Please Login or Register  to view this content.

Compute(cf) above is what VBA indicates to be the error saying: Type Mismatch: Array or user-defined type is expected. So I was wondering how I can call my auxiliary cf function in the main function.

Thanks a lot for the help guys!

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

Instead of x1ToRight use xltoRight. I am not sure that is the only problem but it is certainly a problem.

Declare your function like this:

Please Login or Register  to view this content.

These problems are due to lack of variable type declarations. You should always use Option Explicit and declare all your variables.