asked on # Correcting a Formula Macro in a Complex Spreadsheet

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,

B.

Client-LTV-Assessment-v6.xlsm

Microsoft Excel

Log in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a questionLog in or sign up to see answer

Become an EE member today7-DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform

or

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.

Not exactly the question you had in mind?

Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.

ask a question
hi B,

Thanks for the points - after posting I saw cmeola had beaten me to it, so I really wasn't expecting any points. I'm quite happy for cmeola to have all the points for this one, after all, he/she beat me fair & square by 6 minutes.

Rob

Thanks for the points - after posting I saw cmeola had beaten me to it, so I really wasn't expecting any points. I'm quite happy for cmeola to have all the points for this one, after all, he/she beat me fair & square by 6 minutes.

Rob

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23

Much thanks,

B.