Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range.cells.calculate give error 1004 only in XP
Hi,
One of my users have a workbook originaly designed in excel 97 that have different ranges, in each of thoses ranges the cells contain a RAND(). when run on excel 97 it work perfectly but in XP it give a error 1004 "calculate method of range class failed" the cells and the sheets are not protected and the range have only the "hidden" option On, (I tried to deactivate it and get the same results). I am able to get the value in the range.cells selected but cannot calculate it, must be a new protection feature of XP I do not know... Any help would be appreciate Many Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Run-time error '1004': AutoFill method of Range class failed | Excel Discussion (Misc queries) | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
error 1004 Select method of Range class failed | Excel Programming | |||
error 1004 - metod Copy of class Range was failed | Excel Programming |