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