set range conditional on the numbers of rows

[enfantter]

Hey
does anyone know how to set a range which runs from some cell to "last row".
Its probably simple, but im kinda stucked.

Jack

[Bob Phillips]

=OFFSET($A$1,,,COUNTA($A:$A),1)

If you want to ignore the first row, say it is a header, use

=OFFSET($A$1,1,0,COUNTA($A:$A)-1,1)