<div>
Can you elaborate what you are trying to sum? &nbsp;The values in the columns and rows, by columns separately, by rows separately, or sum the # of Columns and # of Rows?<br />
<br />
Your question is a little vague.
</div>


Can you elaborate what you are trying to sum?  The values in the columns and rows, by columns separately, by rows separately, or sum the # of Columns and # of Rows?

Your question is a little vague.

<div>
Perfect, thats done the trick.<br />
<br />
Thanks Patrick
</div>


Perfect, thats done the trick.

Thanks Patrick

<div>
Seamus2626 - Thanks for thegrade - Patrick
</div>


Seamus2626 - Thanks for thegrade - Patrick

<div>
<div class="content wysiwyg-content">
Hi i have the following lines of code that counts Columns+Rows.<br />
<br />
Can i change this to sum?<br />
<br />
rngYesterday.Columns.Count<wbr /><br />
rngYesterday.Rows.Coun<br />
<br />
Thanks<br />
Seamust
</div>
</div>


Hi i have the following lines of code that counts Columns+Rows.

Can i change this to sum?

rngYesterday.Columns.Count
rngYesterday.Rows.Coun

Thanks
Seamust

Change count to Sum

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