In this question I discovered by accident that there is an "automatic" range name created using the column heading (Excel 2003). I can't replicate this in a new spreadsheet. Is there a setting to do this?
http://www.vbaexpress.com/forum/showthread.php?t=8417&goto=newpost