Google Spreadsheet range names

Question

In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more legible. In most formulas, one can use the range C:C to denote the entire C column, and C2:C to denote the entire C column after and including C2.

Is there a way to create range names of the same nature? When I try C:C or C2:C or Sheet!C:C or 'Sheet'!C:C I always get the error "The range you specified is not in a valid range format." I would like the range name to expand as my form adds rows to my spreadsheet. Thanks.

Answer 1

I just discovered the if you use the '-' operator, it starts from the bottom row. So,

=INDIRECT("-D:D12")

starts from the last row and works it's way up to D12!