Begin with the end in mind

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!