Home > Forum Home > Excel Multiple Regression Analysis and Forecasting Template > Runtime error '1004' with Excel 2007 > Runtime error '1004' with Excel 2007 | Share |
Forum Topic | Login |
Runtime Error '1004' With Excel 2007 | 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 petergroft on |
View Full Post |
Find relevant Excel templates and add-ins for Runtime error '1004' with Excel 2007 in the Excel Business Solutions Directory |