First of all, if you saved it as a "macro enabled workbook file", that means you saved it as a .xlsm file. If so, they could NOT have opened the file with a version of Excel prior to 2010. So, that just leaves a "newer" version, which I wouldn't jump to immediately. Which line is showing the error? without knowing what other macro they ran, it's hard to tell. The macro has (4) named ranges: "GoalSeekPERSIR" "CalPERSImpliedInterestRate" "GoalSeekIndexIR" "BenchmarkImpliedInterestRate" It's possible that one of their other macros either deleted one or more of these ranges, or perhaps you have to have the proper sheet selected for it to run. The fact is, in order to determine what's going on, you have to be able to duplicate the issue. "Reference is not valid" well, what in the macro is a "Reference"? Range names are references. At first, I thought the error "obviously" referred to your .GoTo statements: Application.Goto Reference:="GoalSeekPERSIR" Application.Goto Reference:="GoalSeekIndexIR" Application.Goto Reference:="R16C1"
But, I tested to see if this error occurred if the range name no longer existed. Instead, I got: "Run-time error '1004': Application-defined or object-defined error" Slightly different, so my guess is that either the range "CalPERSImpliedInterestRate" or "BenchmarkImpliedInterestRate" has been deleted or otherwise no longer available. Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- From: deanalt via MS EXCEL AND VBA MACROS <[email protected]> >To: [email protected] >Sent: Friday, July 18, 2014 9:18 PM >Subject: $$Excel-Macros$$ run-time error '1004': Reference is not valid. > > > >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 [email protected]. >To post to this group, send email to [email protected]. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
