| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
runtime error '1004' object '_Global' failed
When I open the Excel file via Excel my macro works fine.
When I open the file via Windows Explorer the macro errors with a runtime error '1004' object '_Global' failed on the following line. UserForm1.Label3 = Worksheets("tables").Range("name_select").Value Any reason for this? Thanks Jim in Spokane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
| Runtime Error 1004 - Method Range of '_Global failed' | Excel Programming | |||
| Error '1004' (Method 'Cells' of '_Global' Failed) On chart creation? | Excel Programming | |||
| Error 1004: Method 'Cells' of object '_Global' failed | Excel Programming | |||
| "Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming | |||
![Jim in Spokane[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
