Take a look he

http://cpearson.com/excel/named.htm#Dynamic


In article ,
Henry San Diego <Henry San wrote:

How do I refer a row range, say C1:Cx where x is the last non-empty row in
the C column, but x may change from time to time.