Debt Sculpting VBA for Solar Energy Project Financing [Request for general code review]

Hello Excel Forum,

We have created a free-to-use, open-source, financial model we call "Abacus" for use in renewable energy transactions. In the current model, we have fully-functioning VBA macros which can 1) sculpt debt by cutting and pasting the calculated values until the difference between the calculated and pasted value equals zero, and 2) maximizes the usage of leverage to stay within target metrics. I'm happy to say the macros work very well, but given our knowledge of VBA is intermediate, we could use the help of any experts who could help us speed up our macros or simplify our code would be an enormous help.

You can find more information on our project at getabacus dot org.

Under the open-source model we will, of course, recognize any help given with a shoutout in our changelog!

Would anyone be able to do a review of our VBA macros (1-2 pages total code) to see what improvements can be made?

Best Regards,

The Abacus Team

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

Since this is your first post and we do not allow hot links for new posters, here it is:

https://www.mrexcel.com/board/thread...jects.1140708/

Please see my comments in the code. I have made very little actual change.

Please Login or Register  to view this content.