![]() ![]() We’ll leverage the macro recorder in Excel to handle most of the actual code. The record macro tool will allow Excel to convert our manual steps into VBA code. We will then identify the key pieces of code to change. Then we will create a loop to dynamically select and replace these values and run the solver again. This will be semi-technical but through this style of development we can focus on the process and the concepts instead of focusing on how to write code. The macro record functionality is found in the developer tab in the ribbon. This is not available by default but is easy to implement. If you navigate to your ribbon options you will see a checkbox for the developer tab. The screenshot below is for Mac but PC based Excel is similar. If you have not installed the solver add-on you can install it via the Add-ins menu. ![]() The Microsoft support site has instructions for all platforms, Load the Solver Add-in in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |