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