Hi,

You're using Excel 2007 so on the Ribbon go to the Formulas tab and then either click on Name manager or "Name a Range" (this might also be called "Define Name" - I only have XL 2003 at work so I can't check) to get the named range set up. Have a read through this for further information - names are a very, very useful tool.

http://office.microsoft.com/en-us/ex...010147120.aspx