hi,

Another option is the use of "dynamic named ranges" which I have used successfully, see the below link for some instructions involving the use of Offset & count functions which I found after entering the above phrase into Excel Online Help.

HTML Code: 
This works very well when maintained within the original workbook but the named ranges can cause problems if charts are copied from workbook to workbook.

Bryan/others, do you have any other negatives which may impact through the use of named ranges?

hth
Rob