Excel VBA Code Issue

[Karma31251]

Sheets("Orders").Range("A2:G200").Select I have this code in a macro in a module on one workbook. I know the sheet is there, and the code will actually run every now and again but most of the time when i go to run the macro it gives me a 1004 runtime error, Select Method of Range Class Failed, I can't understand why this code will run only sometimes, its like there is a bug in the excel. Its simple straight forward code but it just won't go. Karma

[Wendelius]

One problem could be that you have not defined the workbook where the sheet Orders is. So if the topmost workbook is not containing such sheet, it will fail.

The need to optimize rises from a bad design. My articles[^]