Happy to help.

You would do well to have a look as this link on Dynamic Named Lists

http://www.cpearson.com/Excel/excelF.htm#DynamicRanges

and follow the links from there