Summing values is pretty simple in Excel with a spreadsheet and the SUM() function. You just set a cell to have a formula, ‘=SUM([Range]),’ and you can sum the values in any Range. But how can you the same in VBA? It took me a bit of digging to figure this one one, surprisingly. IContinue reading “Excel VBA Sum Range Of Cells”