Macro - Reporting Variable Scenarios

[pflam]

Hi,

Im trying to run a scenario analysis with VBA and have almost succeeded except for one small problem. The below macro runs scenarios for a dependent variable (T12), calculated in Calculator Worksheet, across each change in the independent variable (C5 to F5) however it only reports the result of the last iteration of independent variables (F5) shown in the row below (C6 to F6). Is there any way to change below code so that each scenario outcome (value of T12) is reported below the independent variable associated with it? In other words if T12 = 100 when Independent C5 is used then C6 shows 100 etc. Pls let me know if anything's unclear.

Thank you.

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.