i-nth - Begin with the end in mind

11 April 2015

Today's post is about the Goal Seek Method of the Range Object of the Excel Object Model.

I can use Goal Seek to manually find a value, but what if I need to find values for 12 different months? 52 Weeks? Some other scenario with 100's of desired outputs? Time for some VBA!

Full article: Begin with the end in mind

Connexion
Data Prose
Goal Seek

Essential reading

Bibliography

See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.

Latest articles

Spreadsheets as a source of analytical and accounting problems
Self-checks in spreadsheets: A survey of current practice
The development of a structured methodology for the construction and integrity control of spreadsheet models
Refactoring meets spreadsheet formulas
Simple spreadsheet test case application to test spreadsheet formula in end-user software engineering
Proper VBA error handling
VBA Like operator – using wildcards in conditional statements
Count cells with text and formula – Excel stats
VBA: The VBA array
Excel Tables
An innovative spreadsheet authoring environment

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.