Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Runtime error '1004' with Excel 2007 Share

Runtime error '1004' with Excel 2007

Excel Help for Runtime Error '1004' With Excel 2007 in Excel Multiple Regression Analysis and Forecasting Template


Forum TopicPost Reply Login

Runtime Error '1004' With Excel 2007

Rate this:
(3/5 from 1 vote)
SadI also always get Run-time error '1004' when I click Run Forecast button. I should have the latest version (downloaded two weeks before). I'm working with Excel 2007, German version.

Thanks for any help

bbi
 Posted by on
 
Replies - Displaying 1 to 3 of 3Order Replies By: Most Recent | Chronological | Highest Rated
Confused
Rate this:
(4/5 from 2 votes)
When you use a VBA code to select a range that is not in the active worksheet, VBA will show you the run-time error 1004. Because, if you want to select a cell or range of cells for a particular worksheet needs to be active at that point. You cannot select a cell from sheet1 if sheet2 is active right now.

Hope This Helps,Peter
 Posted by on
Oops
Rate this:
(3/5 from 1 vote)
Thank you for alerting this.  I just tried it with Excel 2007 and German regional settings.  The regression ran fine with the example input data.

If you have changed the input data, you can send you template through as an attachment by replying to the notification email of this post, and we will investigate to resolve the issue.
 Excel Business Forums Administrator
 Posted by on
Confused
Rate this:
(3/5 from 1 vote)
Troubleshooting StepsStart Microsoft ExcelOn the Menu Bar select "File" > "[Excel] Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings"In the top section, select the radio button for "Disable all macros with notification"In the bottom section, check the box for "Trust access to VBA project object model"Click "OK" and "OK" to save the settingsClose ExcelWhen generating a new ADI spreadsheet, Excel will ask if the Macros should be allowed to run.  Allow the macros to run.  Only enable macros from trusted sources.
Regards,Rachel Gomez
 rachel
 Posted by on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for Runtime error '1004' with Excel 2007 in the