Using formulas and indexed ranges

[Bert Vanpeteghem]

Hello,

I'm trying to insert a formula in a cell, based on indexed ranges. I.e. I know i need the sum of the range (3,5) to (3,7), but how do I translate that into Excel ranges ?

[Bert Vanpeteghem]

Answering my own noob question:

AddressLocal property of a Range

>Hello,

I'm trying to insert a formula in a cell, based on indexed ranges. I.e. I know i need the sum of the range (3,5) to (3,7), but how do I translate that into Excel ranges ?