SUM value "in one shot only"

[sal21]

Based the attached workbook is possible to sum in "in one shot only" the value in column D?

Note:
i know the initial range strted from D2 but dont know the and of list. I fill dinamiclly this column.

TKS resolved with

...

Code: Select all

RIGA = WS.Range("A65536").End(xlUp).Row '- 1
SOMMA = Application.WorksheetFunction.Sum(WS.Range("D2:D" & RIGA))

...