SUMM with cells range

[sal21]

I need to summ with the WorksheetFunction.Sum statement the range from B2 to BG2 but using cells range, is possible?

Correct this:
MY_TOTAL = WorksheetFunction.Sum(WS.Cells(1, 60))

[HansV]

MY_TOTAL = WorksheetFunction.Sum(WS.Range(WS.Cells(2, 2), WS.Cells(2, 59)))

B2 = row 2, column 2
BG2 = row 2, column 59

You haven't reacted to the replies in Post=21597 and Post=21116

[sal21]

MY_TOTAL = WorksheetFunction.Sum(WS.Range(WS.Cells(2, 2), WS.Cells(2, 59)))

B2 = row 2, column 2
BG2 = row 2, column 59

You haven't reacted to the replies in Post=21597 and Post=21116

Sorry me but i'm very busy
the solution is perfect!