| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '1004': Method 'Range' of object '_Global' failed
thanks Tim. you hit it on the nose!
-- Neild "Neild" wrote: i am developing an excel application to run on a network server which uses several userforms. the userforms collect data in variables and then write them to cells in several worksheets. the application works correctly when run on my local workstation but when i try to run it from the network, i get this error message. i have located an article Q213655 relating to this error which suggests using the .Evaluate method in place of the Range.value method however it refers to getting a value from a cell and placing it in a variable value. i have tried to apply the Evaluate method in the opposite direction (ie placing a variable value from the userform into a cell in a worksheet) but i get the same '1004' error message. does anyone have a solution other then avoiding userforms in the network environment? -- Neild |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run-time error '1004': Method 'Range' of object '_Global' failed | Excel Programming | |||
| 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 object '_Global' failed | Excel Programming | |||
| "Run-time error '1004'" Method 'Range' of object '_global' failed. | Excel Programming | |||
Threaded Mode
