I've been out all week on holiday or would have answeredsooner. Here is a introduction to dynamic range names:http://www.grbps.com/Excel5.pdfYou might also have a look at the VBA property .CurrentRegion