Simple Macro for Sensitivity Analysis

pflam

New Member
Joined
Oct 10, 2013
Messages
7
Hi,

Ive used data tables a fair amount in excel but given the time they take to recalculate (i have many in one s/sheet) im looking to create a macro rather which only runs when i choose to run it, but I've never really used macros before so am hoping for an easy example to get started.

Ive looked in the forum but cant seem to find an example of a simple macro which shows how to perform 'what-if' or sensitivity analysis on a variable calculated in a s/sheet - by assuming different values for a dependent variable also referenced in the s/sheet - so would appreciate any pointers.

Thank you.

p.s. im aware of the possibility of putting Calculation Options to 'Automatic except Data tables' but it is still very slow when one opens or saves the s/sheet and 'Manual' doesn't work for me as need rest of the worksheet to be dynamic.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,098,992
Messages
5,465,867
Members
406,452
Latest member
GroupGoal

This Week's Hot Topics

Top