<div>
<div class="content wysiwyg-content">
In MS Excel, there is a &nbsp;' =SUM(A1:I1) ' for addition.<br />
<br />
But if I want to do subtraction from A1 to D1, then I have to do <br />
this :<br />
<br />
&nbsp; &nbsp;=A1-B1-C1-D1<br />
<br />
Is there a way to create this build in function like :<br />
<br />
&nbsp; &nbsp;=SUB(A1:D1)<br />
<br />
by using VB ?<br />
If yes, how ? PLease show me. Thank a lot !
</div>
</div>


In MS Excel, there is a  ' =SUM(A1:I1) ' for addition.

But if I want to do subtraction from A1 to D1, then I have to do 
this :

   =A1-B1-C1-D1

Is there a way to create this build in function like :

   =SUB(A1:D1)

by using VB ?
If yes, how ? PLease show me. Thank a lot !

vb in ms 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.