Re: Excel 2007 Help: Naming A Range Of Cells

  • From: "Don Marang" <donald.marang@xxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Wed, 2 Mar 2011 16:02:27 -0500

 Sorry, I have not used that feature yet.  Normally a defined name can be used 
in place of cell coordinates.  

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 
Sent: Wednesday, March 02, 2011 1:54 PM
To: programmingblind@xxxxxxxxxxxxx 
Subject: RE: Excel 2007 Help: Naming A Range Of Cells


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 

Sent: Wednesday, March 02, 2011 1:07 PM

To: 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.

Other related posts: