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

--
Thks
Bill Leroy

Details?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill Leroy" wrote in message
...
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

--
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

"Bill Leroy" wrote in message
...
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

--
Thks
Bill Leroy

It works great
--
Thks
Bill Leroy


"David Biddulph" wrote:

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

"Bill Leroy" wrote in message
...
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

--
Thks
Bill Leroy

Glad to hear that it worked.
--
David Biddulph

"Bill Leroy" wrote in message
...
It works great
--
Thks
Bill Leroy


"David Biddulph" wrote:

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

"Bill Leroy" wrote in message
...
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

--
Thks
Bill Leroy