Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goal Seek (in VBA)
[This followup was posted to microsoft.public.excel.programming with an
email copy to Matt. Please use the newsgroup for further discussion.] Ummm...kinda hard to help without knowin the possible cause of the problem. How about posting the problem code segment? -- Trouble finding replies to your posts? Use a newsreader. See the tutorial 'Outlook Express and Newsgroups' on my web site Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I've used VBA to make my goal seek "target" a variable number, however when goal is used it is not always finding a result. A result does exist as I can find it manually. Does anybody know how to fix this? Any help would be greatly appreciated. Thanks Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goal Seek (in VBA)
Just dynamic goal seek - but goal seek won't always give
me an answer Range("BJ23").Select Range("BJ23").GoalSeek Goal:=Range("BK23").Value, ChangingCell:=Range("BJ22") -----Original Message----- [This followup was posted to microsoft.public.excel.programming with an email copy to Matt. Please use the newsgroup for further discussion.] Ummm...kinda hard to help without knowin the possible cause of the problem. How about posting the problem code segment? -- Trouble finding replies to your posts? Use a newsreader. See the tutorial 'Outlook Express and Newsgroups' on my web site Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I've used VBA to make my goal seek "target" a variable number, however when goal is used it is not always finding a result. A result does exist as I can find it manually. Does anybody know how to fix this? Any help would be greatly appreciated. Thanks Matt . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Goal Seek | Excel Discussion (Misc queries) | |||
goal seek | Excel Discussion (Misc queries) | |||
Goal seek gone | Excel Worksheet Functions | |||
Goal Seek | Excel Worksheet Functions |