Hi Don, Thanks for this. Got it. Now I'd like to use my named range as the values in a list box. How do I do that. When I try it, the list box has no values in it. I go to the Data tab and choose Data validation, then I pick List, and try to type in a formula that looks like =name_range, where name_range is the real name of my range. I've also tried to type in something like A2:A352. What am I doing wrong? Thanks. Jim From: programmingblind-bounce@xxxxxxxxxxxxx [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Don Marang Sent: Wednesday, March 02, 2011 1:46 PM To: programmingblind@xxxxxxxxxxxxx Subject: Re: Excel 2007 Help: Naming A Range Of Cells Select the cell or range of cells to name, then hit the Applications key. Name a range will be in the list of available actions in the context menu. Don Marang Vinux Software Development Coordinator (vinux.org.uk) There is just so much stuff in the world that, to me, is devoid of any real substance, value, and content that I just try to make sure that I am working on things that matter. Dean Kamen From: Homme, James<mailto:james.homme@xxxxxxxxxxxx> Sent: Wednesday, March 02, 2011 1:07 PM To: programmingblind@xxxxxxxxxxxxx<mailto:programmingblind@xxxxxxxxxxxxx> Subject: Excel 2007 Help: Naming A Range Of Cells Hi, I give up. What's the keyboard shortcut to name a range of cells in Excel 2007? Thanks. Jim ________________________________ This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.