Editing Goal Seek in Excel
Posted on 2003-11-21
i set up a macro to output the goal-seek result from a BINOMDIST cell:
Range("C5").GoalSeek Goal:=Range("E4"), ChangingCell:=Range("B4")
Where C5 has the value:
I wrote the program to help find the critical values of a binomial distribution, but sometimes running the macro results in extremely low results like:
and then trying to re-run the macro results in a
Run Time Error '1004':
Reference is not valid.
Firstly is there a way to stop the error, secondly is this a good way to go about finding the critical values, and thirdly (if not) what's a better way?
Thanx in advance