I presently have a rather complex Spreadsheet that was constructed out of a number of EE Professional macros. I've now made some formula changes and have what I hope is a simple problem to resolve. If you open the attached file, you will find the spreadsheet LTV. The Function button allows for the formulas to be returned to the appropriate cells if a absolute value is overwritten into a cell. So for example, if you choose 5 in cell D4 you will get a 5 year analysis with the cells auto populated with formulas. If you override, say F5 and make it a number it will behave correctly. If you press the Formula button, that is where I get a compile error.
Help! And Thanks,