Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Insert, Name

Posted on 2009-04-21
Medium Priority
Last Modified: 2012-05-06
I've have driven myself nuts trying to get tis to do anything. I would like to name a range of cells and then use that name in formulas and macros. What am I mising? Thanks! You folks are a Godsend.
Question by:pubbuddy
1 Comment
LVL 81

Accepted Solution

byundt earned 2000 total points
ID: 24194079
In Excel 2003 and earlier, you create a named range using the Insert...Name...Define menu item.
1) Select the desired cells
2) In the Insert menu, choose Name, then click the arrow to its right and choose Define
3) Put the desired name in the "Names in workbook" field at the top
4) Click OK

You can then use that name in a worksheet formula. If you want to use it in a macro, you must enclose it in square braces. If the name is DataTable, then you might use it like this:

=VLOOKUP(A1,DataTable,3,FALSE)           worksheet formula

Sub MyMacro()
MsgBox [DataTable].Address       'Display the address of named range DataTable
End Sub


Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question