Avatar of Bright01
Bright01
Flag for United States of America 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

Avatar of undefined
Last Comment
Rob Brockett

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
cmeola

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
Sign up - Free for 7 days
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
SOLUTION
Rob Brockett

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
Sign up - Free for 7 days
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
Bright01

ASKER
Both of you "nailed" this problem.  Much thanks.... now I can proceed on this project!

Much thanks,

B.
Rob Brockett

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
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