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