NPV and dragging down the formula

[billyshears]

I am taking a NPV for several rows of data. How can I write my formula so that the range in the NPV formula always starts on the row i am in, and ends on the last line of the range?

For example:

A1
A2
A3
A4
A5

My formula in Cell B1 would use the range A1:A5

I just want to be able to drag that down, so the range used in B2 is A2:A5 and so forth

Thanks

[bebo021999]

Change the range A1:A5 to A1:A$5 instead