I need to update the formulas i a large number of similar files, and have written a small routine to update cells with an new formula..
Range("R9").Formula = "=SUMMERPRODUKT($K$15:$K$108;R15:R108;$I$15:$I$108)"
fails, and returns the message "Application-defined or object-defined error", but I don't understand why..
The SUMMERPRODUKT is the Norwegian version of SUMPRODUCT
Please help.. :)