Record a macro that runs solver to maximize return on Portfolio A, then runs again to minimiza Be sure to \"Clear" the Solver before each optimization. Allow 20% short sales and 30% long for each asset. Edit the VBA and clean out duplicate and unneeded lines of code. Add a Message Box that asks whether or not to run the optimization, then add and if stat: Add an InputBox that asks for the maximum and minimum off each stock (one max for a Record another macro that resets the weights to the original equal weight position