<div>
Perfectamundo!<br />
<br />
I had to convert the integer to a string, but once I did that, concatenating the string elements as you suggested worked like a charm.<br />
<br />
Thanks!
</div>


Perfectamundo!

I had to convert the integer to a string, but once I did that, concatenating the string elements as you suggested worked like a charm.

Thanks!

<div>
<div class="content wysiwyg-content">
I have successfully used this code:<br />
<br />
.Cells(intR, intC).FormulaR1C1 = &quot;=Sum(R[-2]C:R[-1]c)&quot; to put a Sum formula into and Worksheet.<br />
<br />
Now I am trying to use this code:<br />
<br />
.Cells(intR, intC).FormulaR1C1 = &quot;=Sum(R[-intSumRowCounterR<wbr />ow]C:R[-1]<wbr />c)&quot;<br />
<br />
The difference in the situations is that in the first, I KNOW I always will want to sum two rows. In the second case, the length of the column I want to sum varies, and is being counted in the variable &quot;intSumRowCounterRow&quot; as rows are added. The error that it is throwing is:<br />
<br />
&quot;EXCEPTION from HRESULT: 0x800AO3EC&quot;.<br />
<br />
Any advice on how to insert the formula would be appreciated.<br />
<br />
Thanks.
</div>
</div>


I have successfully used this code:

.Cells(intR, intC).FormulaR1C1 = "=Sum(R[-2]C:R[-1]c)" to put a Sum formula into and Worksheet.

Now I am trying to use this code:

.Cells(intR, intC).FormulaR1C1 = "=Sum(R[-intSumRowCounterRow]C:R[-1]c)"

The difference in the situations is that in the first, I KNOW I always will want to sum two rows. In the second case, the length of the column I want to sum varies, and is being counted in the variable "intSumRowCounterRow" as rows are added. The error that it is throwing is:

"EXCEPTION from HRESULT: 0x800AO3EC".

Any advice on how to insert the formula would be appreciated.

Thanks.

Inserting Excel Formula with Variable from VB2010

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.