| || |
VBA method to excel cell sum
As Iím writing VBA code in excel visual basic editor.
I searched in the Google for an vb/vba method to sum the number values in the excel cells (example cell (d4 to d32) , and this value I need to assign to an variable, this should happen automatically), but Iím unable to find right one, hence any one of you has method, please let me know.
Thanks in advance for your response.
Re: VBA method to excel cell sum
I got solution , here is answer:
Set RangeSum1 = sh.Range("E34:E37")
intrval = Application.WorksheetFunction.Sum(RangeSum1)