You're right it is, but you are failing (at least with me).

You are not working with ranges, just declaring an array of type range doesn't get anything in there. And if you want to sum them, I preume that you want to just sum the values, so what is wrong with

[vba]

Range("H1").Formula = "=SUM(A1:A10)"
[/vba]

but you say that you don't want to use A1:A10 notation, but don't say why not. If it is because the range is determined dynamically within the code you can use

[vba]

Range("H1").Formula = "=SUM(" & some_range.Address & ")"
[/vba]

If not, then I still am at a loss as to what you are trying to do.