SuedeGopher
New Member
- Joined
- Apr 19, 2014
- Messages
- 4
Howdy minds of MrExcel, long time reader, first time poster.
Normally I find the droid I am looking for with the handy search feature, but this time I'm coming up empty. My skills are pretty rudimentary and I'm often not able to combine ideas like I'd like to. End of sob story, beginning of begging for help!
I am trying to set up a statement with a goal seek. There are currently three different variables I'd like to use as my basis, all with the same seek cell and the same cell to change. Basically I have a drop down box and the value to be sought, then I'm trying to have my statement read the contents of the cell and use that name to know where to point to. Here's what I built that works like not at all:
So in that example, I manually set the Goal Seek value to ROA, but I'd like to be able to be able to read off of my drop down box to decide what range to set.
Does that all make sense and if so, who want some good Karma for helping an idiot!?!
Normally I find the droid I am looking for with the handy search feature, but this time I'm coming up empty. My skills are pretty rudimentary and I'm often not able to combine ideas like I'd like to. End of sob story, beginning of begging for help!
I am trying to set up a statement with a goal seek. There are currently three different variables I'd like to use as my basis, all with the same seek cell and the same cell to change. Basically I have a drop down box and the value to be sought, then I'm trying to have my statement read the contents of the cell and use that name to know where to point to. Here's what I built that works like not at all:
Code:
Sub GSeek()
With Worksheets("Inputs")
Dim ChngCell As String
Dim ROA As Range
Dim Payment As Range
Dim Yield As Range
ChngCell = Range("M40")
Set ROA = Range("N35").Value
Set Payment = Range("B16").Value
Set Yield = Range("C14").Value
ROA.GoalSeek _
Goal:=.Range("N40").Value, _
ChangingCell:=.Range("B15")
End With
End Sub
So in that example, I manually set the Goal Seek value to ROA, but I'd like to be able to be able to read off of my drop down box to decide what range to set.
Does that all make sense and if so, who want some good Karma for helping an idiot!?!