<div>
Hi uTab,<br />
Try using Application.Pmt<br />
Worksheets(&quot;Compound_Calcu<wbr />lations&quot;).<wbr />Range(&quot;cal<wbr />cpaymentc&quot;<wbr />) = -Application.Pmt(Cells(rw,<wbr /> colIRate) / 2, Range(&quot;issue_term&quot;) * 2, Range(&quot;sissue&quot;))<br />
<br />
Cheers!<br />
<br />
Brad
</div>


Hi uTab,
Try using Application.Pmt
Worksheets("Compound_Calculations").Range("calcpaymentc") = -Application.Pmt(Cells(rw, colIRate) / 2, Range("issue_term") * 2, Range("sissue"))

Cheers!

Brad

<div>
Brad Thanks for helping but David Barker got it.<br />
<br />
Huge thanks to the both of you.<br />
<br />

</div>


Brad Thanks for helping but David Barker got it.

Huge thanks to the both of you.



<div>
<div class="content wysiwyg-content">
I have the following code and am receiving the above error:<br />
<br />
rs = 30<br />
&nbsp; &nbsp; re = (trm * 2) + 30 - 1<br />
&nbsp; &nbsp; rc = Int((re - 30 + 1) / 3 * 2 + 30)<br />
&nbsp; &nbsp; colIRate = Worksheets(&quot;Simple_Calcula<wbr />tions&quot;).Ra<wbr />nge(&quot;irate<wbr />&quot;).Column<br />
&nbsp; &nbsp; Worksheets(&quot;Compound_Calcu<wbr />lations&quot;).<wbr />Range(&quot;cal<wbr />cpaymentc&quot;<wbr />) = -Pmt(Cells(rw, colIRate) / 2, Range(&quot;issue_term&quot;) * 2, Range(&quot;sissue&quot;))<br />
<br />
The error is with Worksheets(&quot;Compound_Calcu<wbr />lations&quot;).<wbr />Range(&quot;cal<wbr />cpaymentc&quot;<wbr />) = -Pmt(Cells(rw, colIRate) / 2, Range(&quot;issue_term&quot;) * 2, Range(&quot;sissue&quot;))<br />
<br />
Can anyone help?<br />

</div>
</div>


I have the following code and am receiving the above error:

rs = 30
    re = (trm * 2) + 30 - 1
    rc = Int((re - 30 + 1) / 3 * 2 + 30)
    colIRate = Worksheets("Simple_Calculations").Range("irate").Column
    Worksheets("Compound_Calculations").Range("calcpaymentc") = -Pmt(Cells(rw, colIRate) / 2, Range("issue_term") * 2, Range("sissue"))

The error is with Worksheets("Compound_Calculations").Range("calcpaymentc") = -Pmt(Cells(rw, colIRate) / 2, Range("issue_term") * 2, Range("sissue"))

Can anyone help?


Application-defined or Object-defined error

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