Thank you very much, Paul. When I received the file, it was quickly
obvious that this other party had introduced an error into the file that
was producing a bunch of #0's and such and that the goal seek would never
be able to find a solution. I guess these VBA error messages are just too
generic for my tastes. It seemed more like the kind of messge you get
when something isn't dimensioned properly, etc. I expected something a lot
more subtle! Next time I will know to ask for the file first, before I go
jumping to conclusions.
Thanks again for your very thoughtful answer.
Dean
On Friday, July 18, 2014 6:18:06 PM UTC-7, deanalt wrote:
>
> I sent someone an EXCEL macro enabled workbook file (created in EXCEL
> 2010) and they ran some macros, saved the result, then later tried to run a
> different macro and got the error message in the subject line. I had no
> such problem in running it just the way they did it on my computer. It is
> possible they have an older or newer version of EXCEL than I do, i.e., not
> 2010. Below is the very short macro. Is there anything here that lends
> itself to not working on a different version of EXCEL?
>
> Even if there is no clue, is there a way to change the macro, maybe by
> declaring something or whatever, to ensure it will probably run on other
> computers better?
>
> I created this macro a long time ago, am a novice at macros, and don't
> recall if I recorded all of this macro or just some of it, then edited it.
> But it works for me just fine.
>
> Thanks so much!
> Dean
>
> Sub ComputeInterestRates()
> Application.MaxChange = 0.000001
> Application.Goto Reference:="GoalSeekPERSIR"
> Range("GoalSeekPERSIR").GoalSeek Goal:=0,
> ChangingCell:=Range("CalPERSImpliedInterestRate")
> Application.Goto Reference:="GoalSeekIndexIR"
> Range("GoalSeekIndexIR").GoalSeek Goal:=0,
> ChangingCell:=Range("BenchmarkImpliedInterestRate")
> Application.Goto Reference:="R16C1"
> End Sub
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
