Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sensitivity Analysis
I need a macro to vary my sales forecast (which are values contained in a
range named "Forecast") by the factor specified in Cell A1. I've written this macro:- Sub Vary() Dim cell As Range For Each cell In Range("Forecast") cell.Value = cell.Value * Range("A1") Next End Sub Although this macro does vary the forecasts by the factor specified in cell A1, the results are all values. I need each cell within the range "Forecast" to actually contain a reference to cell A1 (i.e. *A1). In future, I can vary the forecast by just changing the figure in cell A1 without running any macro. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sensitivity analysis | New Users to Excel | |||
What do I need to do to perform a sensitivity analysis | Excel Worksheet Functions | |||
Excel Sensitivity (What If) analysis | Charts and Charting in Excel | |||
Sensitivity Analysis to 2 variables | Excel Discussion (Misc queries) | |||
Sensitivity analysis | Excel Worksheet Functions |