<div>
what is the quotient function ?<br />
gowflow
</div>


<div>
for sure you will get an error as Quotient is not defined as a function or Sub<br />
<br />
what do you want to accomplish ?<br />
A divide by B and take the full part ? that is the quotient<br />
<br />
gowflow
</div>


for sure you will get an error as Quotient is not defined as a function or Sub

what do you want to accomplish ?
A divide by B and take the full part ? that is the quotient

gowflow

Quotient.xls

<div>
<div class="content wysiwyg-content">
<pre><code id="code-10-28366859-1">For I = 3 To 14
    C(I) = Quotient(A3, B3)
Next I</code></pre>
<br />
The above code returns a compile error Sub or Function not defined.<br />
There are values in A3:A14 and B3:B14 and I'm teaching the use of the Quotient function.<br />
I've tried to hide the results using the &quot;;;;&quot; but that does not work on Errors. Instead I am used the ClearContents. When the user selects a command button labeled Display Data I need to repopulated C(3):C(14) with the Quotient function. which is the code you see above.<br />
I thought of creating a user-defined function but that failed.
</div>
</div>


(CODE)

The above code returns a compile error Sub or Function not defined.
There are values in A3:A14 and B3:B14 and I'm teaching the use of the Quotient function.
I've tried to hide the results using the ";;;" but that does not work on Errors. Instead I am used the ClearContents. When the user selects a command button labeled Display Data I need to repopulated C(3):C(14) with the Quotient function. which is the code you see above.
I thought of creating a user-defined function but that failed.

Problem with VBA code in sub routine

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