Hi everyone,
As this is my first post I'd like to begin by saying that 'Excel forum' has been of huge value to me over the years. The issue that I am having
is running multiple goal seeks on each cell within a range.
Within the attached workbook dynamic named range 'TradePr' is Column 'AW' which I require as my .GoalSeek and 'Required_TM' is Column 'AK' as my, ChangingCell:=
- as for the Goal:= this can be set as Range("BI2").value
So essentially if I were to only calculate the first cell within the range it would be:
Range(”AW5″).GoalSeek Goal:=Range("BI2").value, ChangingCell:=Range(”AK5″)
Really appreciate the help.
Thanks
Bookmarks