<div>
Good Morning,<br />
<br />
Try replacing semi colons ; with commas ,
</div>


Good Morning,

Try replacing semi colons ; with commas ,

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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..<br />
<br />
The line <br />
<br />
Range(&quot;R9&quot;).Formula = &quot;=SUMMERPRODUKT($K$15:$K$1<wbr />08;R15:R10<wbr />8;$I$15:$I<wbr />$108)&quot;<br />
<br />
fails, and returns the message &quot;Application-defined or object-defined error&quot;, but I don't understand why..<br />
<br />
The SUMMERPRODUKT is the Norwegian version of SUMPRODUCT<br />
<br />
Please help.. :)
</div>
</div>


Hi,

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..

The line 

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.. :)

Writing formula in cell with VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.