Not sure i understand the question - what do you want to know?
do you want to know how to develop a function that uses a range - if so, any
particular function
do you want to know how to create a dynamic range - if so, check out dynamic
ranges at www.contextures.com/tiptech.html

Cheers
JulieD


"ACase" wrote in message
...
Hello,

I need to develop a function which uses a range. The range is dynamic
based
upon a Lease Term.

Example: I have a 5 year lease - The range will encompase 5 cells
(A1:E1).
I will always know the starting Cell.

Any help would be much appreciated.

thanks
ACase