| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goalseek "may not have found a solution"
I am using the goalseek as follows
Range("H5").GoalSeek Goal:=0, ChangingCell:=Range("E5") Sometimes I don't get a result. Manual running of the goal seek would give me: May not have found a solution. Whereas in VBA I don't get such a warning and the result is dumped in my oupput cell. Is there some kind of flag or anything which could tell me if the goal seek has found a solution or not...? -- - Mangesh ------------------------------------------ Office 2003 & Windows XP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| "GoalSeek method of Range object failed" error message | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
![Mangesh Yadav[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
