Ranges

[Bill Leroy]

Is it possible to define a range to be used in a formula for which the number
of cells contained in that range depend on a variable e.g. a date in another
cell

 

[Don Guillett]

Details?

 

[David Biddulph]

Yes, you can use the OFFSET function, with the width or height parameter of
the resulting array being determined by a calculation.

 

[Bill Leroy]

It works great
--
Thks
Bill Leroy

Yes, you can use the OFFSET function, with the width or height parameter of
the resulting array being determined by a calculation.

 

[David Biddulph]

Glad to hear that it worked.
--
David Biddulph

It works great