summ value in range

[sal21]

i have:
riga=3 (is my count)

I want to summ the vale in range D&riga to EA&riga and store the result in MY_TOTAL

[VBA Noob]

Hi,

Does this help

Sub SumX()
Dim riga As Integer
riga = 3
Range("MY_TOTAL").Value = WorksheetFunction.Sum(Range("D" & riga & ":EA" & riga))
End Sub

VBA Noob

[sal21]

Hi,

Does this help

Sub SumX()
Dim riga As Integer
riga = 3
Range("MY_TOTAL").Value = WorksheetFunction.Sum(Range("D" & riga & ":EA" & riga))
End Sub

VBA Noob

Hi, work perfect!
Tks.

[VBA Noob]

Glad it helped

VBA Noob