<div>
How is your range defined? Can you describe the size of the range?<br />
<br />
Kevin
</div>


<div>
I have the below information<br />
<br />
Start row &nbsp; &nbsp;End Row<br />
10 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50<br />
60 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 70<br />
250 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 500<br />
<br />
For each of the start and end points I want to sum columns A-Z. &nbsp;Thus, I want to sum <br />
<br />
A10:A50 &nbsp;in A51<br />
A60:A70 &nbsp;in A71<br />
A250:A500 in A501<br />
<br />
b10:b50 &nbsp;in b51<br />
b60:A70 &nbsp;in b71<br />
b250:b500 in b501<br />
<br />
etc..<br />
<br />
My problem is I do not want to write out a line of code for each column start and end points. &nbsp;I was hoping I could loop thru the column numbers to do the calculation as I know I always need to add columns A to Z (can you do a loop on letters a-z ?) &nbsp;Note the start and end points are already stored in a worksheet which I dynamically create each time I run the code.
</div>


<div>
Never had used resize before..thanks for the tip..
</div>


<div>
<div class="content wysiwyg-content">
What is the recommended way in adding a range in MS Excel VBA...When I search the Internet some suggest the below ? &nbsp;Also if I wanted to sum a range, but I have the column number not the latter are there any suggestions for using the column number ?<br />
<br />
Range(&quot;A1&quot;).Formula =&quot;=Sum(A2:B3)&quot;
</div>
</div>


What is the recommended way in adding a range in MS Excel VBA...When I search the Internet some suggest the below ?  Also if I wanted to sum a range, but I have the column number not the latter are there any suggestions for using the column number ?

Range("A1").Formula ="=Sum(A2:B3)"

Adding a range in Excel

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