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

x
Solved

# Insert, Name

Posted on 2009-04-21
Medium Priority
605 Views
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.
0
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()
End Sub

0

## Featured Post

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…
###### Suggested Courses
Course of the Month14 days, 1 hour left to enroll