Using formulas and indexed ranges

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 ?

1 Reply

BV Bert Vanpeteghem October 11, 2007 12:39 PM UTC

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 ?

Loader.
Up arrow icon