Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 832
  • Last Modified:

Editing Goal Seek in Excel

i set up a macro to output the goal-seek result from a BINOMDIST cell:

Sub Macro1()
          Range("C5").GoalSeek Goal:=Range("E4"), ChangingCell:=Range("B4")
End Sub

Where C5 has the value:
  =BINOMDIST(B4,C4,D4,FALSE)

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:
  -152537377.264605

and then trying to re-run the macro results in a
  Run Time Error '1004':
  Reference is not valid.

error.

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
Synthetics
0
Synthetics
Asked:
Synthetics
1 Solution
 
Dave BrettVice President - Business EvaluationCommented:
B4 has to be an Integer so I think you should be wither be using Solver instead of Goalseek or use an INT(Range("B4")) in your goalseek

Cheers

Dave

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now