How do I refer to a non-empty row range in Excel
 

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.
Thanks.
Please reply to .

Henry

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.