Is it possible to sum a named cell range?

[JustATheory]

Greetings,

In Excel I name two cells and can select the range for instance:

range("one", "two").select is there a way that I can sum this range?

Thanks,
Andy

 

[PHV]

Like this ?
MsgBox Application.Sum(Range("one","two"))

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Hi,
[tt]
n = application.Sum([one], [two])
[/tt]


Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[JustATheory]

Thank you both, they both work well.

Thanks,
Andy