On 01/26/2016 09:02 AM, Larry Evans wrote: > 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? > > Some one else had a similar question:
https://forum.openoffice.org/en/forum/viewtopic.php?f=45&t=4331&start=0 I'm studying that to see if that will help. However, apparently, the code in the above GSeek won't work in libreoffice :( -- To unsubscribe e-mail to: [email protected] 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
