Lock the start cell with absolutes

$A$1:A3

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"fedude" wrote in message
...
Is there a way to define a range based upon the current cell location?
For
instance When I'm calculating a formula in C3 I want to use the range
A1:A3,
but when I move down to C4, I want the range to be A1:A4.

The top of the range will remain constant, but the bottom of the range
will
move based upon the row I'm currently in.