On 01/26/2016 08:42 AM, Larry Evans wrote: > On 01/26/2016 07:18 AM, Andreas Säger wrote: >> Am 26.01.2016 um 11:47 schrieb Larry Evans: >>> I've checked that the value returned by the YIELD function: >>> >>> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD >>> >>> can be gotten by using [Tools>Goal Seek...] and the PV function: >>> >>> https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV >>> >>> Is there some way I could use a something like a GOAL_SEEK function >>> to implement my own version of YIELD? IOW, without having to go >>> through the answering of the [Goal Seek] dialog window requesting >>> Formual cell, Target Value, and Variable cell? >>> >>> TIA. >>> >>> -regards, >>> Larry >>> >>> >> >> menu:Tools>Goal Seek ? >> >> > As mentioned in my message, I've used that from the UI. > What I want is to call some function, GOAL_SEEK, from within > a macro. Sorry I wasn't clearer. I'm guessing > YIELD *must* be implemented using some such function, and > I was hoping a macro could somehow get access to that function > even though there's no GOAL_SEEK function in the published > set of functions. > > Hope that's clearer. > > -regards, > Larry >
I want something along the lines of: Sub GSeek() With Worksheets("Sheet1") .Range("H18").GoalSeek _ Goal:=.Range("H32").Value, _ ChangingCell:=.Range("G18") End With End Sub shown here: http://stackoverflow.com/questions/18139322/goal-seek-macro-with-goal-as-a-formula Would that code work in libreoffice? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted