Data table applying macro button

[Competitive_kangaroo]

Hi guys I posted this problem before but no one seems to reply but I hope it captures someone's attention this time. Please help.

So I assign a macro button to solve the circular reference in calculating IRR in a real estate financial model.

Next, I have a data table to analyze different scenarios regarding my IRR. The problem here is the data table will only calculate the IRR without applying my macro button which makes it incorrect.

So I am asking for pros here the best way regarding my situation.

Thank you for any helpful reply.

 

[Competitive_kangaroo]

So basically what I want to do is every single results in my data table did apply my VBA command. Right now they don't so the results are incorrect. Thanks guys.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-table-applying-macro-button.html#post5121238

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.