A fixed or dynamically defined range of cells that has been assigned a name by a user. Named ranges are used in Microsoft Excel and similar spreadsheet applications. Named ranges may be referred to in formulas or in code and are useful for convenient reference and improved formula readability.

learn more… | top users | synonyms (1)

-1
votes
1answer
18 views

How do I reference a specific row number using a defined column name?

I'm using Excel 2010 and am creating a workbook to define details about products in a store (including category, price, accessories). I also want to define default details to use if the specific ...
0
votes
0answers
33 views

How can I check that a filter applied to a listobject column with vba is legal?

Filtering a listobject(excel table) with a value that doesn't exit results all rows instead of none can I get no rows? can I get list of optional legal parameters? example listobject with col A ...
1
vote
1answer
132 views

Creating Dynamic, Unique Arrays Dependent on Multiple Criteria or Subset of Data

I have a Table structured in this manner: City Region Date Value ABC 123 Jan1 10% DEF 999 Feb1 7% The table is fed by user-entry, but there is an important rule: ...
0
votes
1answer
26 views

Calculating Named Ranges

The spreadsheet contains numerous named ranges. I need to refer to those ranges using VLOOKUP. Here's the kicker, I want to refer to the ranges via a text manipulation. Case. Column A contains list ...
0
votes
1answer
177 views

Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank. But when I use this defined name in another cell, the second ...
0
votes
1answer
62 views

How to call a namer range using a variable to define the name

According the documentation, any quoted text names can be defined by a variable If I define Set xlsDataSource = Application.Workbooks("New_TOR_V1.xlsm").Names("MyRange").RefersToRange it works as ...
0
votes
0answers
25 views

Excel 2010 dynamic charting : how to build a named range from another one

I'm charting 2 series, X and Y, which are named ranges. I need to add one point at the end of the chart, i.e. the trend for the incoming week. No problem for the X data, easy. The problem is for the Y ...
0
votes
1answer
267 views

Insert columns, within a range, based on cell reference

So am trying to tell VBA to insert a certain number of columns between two other columsn based on a cell reference. I've managed to get excel to insert columns within my range: Sub INSERT() ...
1
vote
1answer
234 views

Get the row and column for a cell in a named range?

Given a cell that exists in a named range, what's the cleanest way to get the row and column numbers for that cell inside the named range? In other words, I want the row and column number relative to ...
2
votes
1answer
104 views

Can the name of a named range be dynamic?

I'd like the name of a named range in excel to be dynamic (as opposed to the range itself!). I'd like to know if/how I can define a range name using a formula or reference cell, so that the name ...
2
votes
2answers
3k views

Excel reference named range with text and formula

Is it possible to refer to a named range by combining text with a formula? Say I get a name for a range via INDEX which returns a text but I also want to add something after the text like so: ...
1
vote
1answer
319 views

Fill formula containing named range but change named range based on relative reference

I have a formula that I need to copy in many cells, but I don't know how to copy a named-range reference to another cell without changing it. NamedRange (a table imported from database connection) ...
0
votes
2answers
3k views

Excel - Counta from a certain cell until a blank cell

I'm trying to create a dynamic formula which counts all the rows from cell D3 downwards until a blank cell is reached. I want to be able to add new data everyday and have the range automatically ...
1
vote
3answers
8k views

Creating a chart using a dynamic named range in Excel 2010

I am trying to create a scatter plot in Excel 2010 using dynamic named ranges and am having trouble getting it to work. Here's simple example that is failing: Open Excel, starting a new workbook ...
3
votes
2answers
8k views

Excel Name.RefersToRange: how to check if Name object refers to a range?

The Microsoft documentation says about RefersToRange: If the Name object doesn't refer to a range (for example, if it refers to a constant or a formula), this property fails. I'm trying to ...
1
vote
1answer
384 views

How exactly do I create “Dynamic Named Ranges”?

I'm trying to create a "Dynamic Named Range" in Excel so I can populate an X/Y values table inside of it in Java. I've seen tutorials, but I still don't get it. I know I have to use the =OFFSET() ...
3
votes
2answers
4k views

How do I prevent VLOOKUP from breaking after I add a column to a named range?

My Excel worksheet contains a lot of VLOOKUPs on a named range that I have defined. Now, when I added a column in the middle of my named range, the VLOOKUPs that reference columns after the inserted ...
2
votes
1answer
256 views

How do you make the Named Ranges box bigger in Excel?

The box with the Named ranges in it is too small to see the whole name sometimes, so I have to open the Insert Name dialog. How do I increase the width of the Named Range box (I don't mind shrinking ...
4
votes
1answer
8k views

Shortest Method To Reference A Single Row/Column of a Named Range in Excel?

I have a named range (NamedRange1) and I need to reference the first row and first column of that range within a formula. I came up with the following: First row: INDIRECT("R" & ...
5
votes
2answers
7k views

What's the difference between a Table and a Named Range in Excel 2007?

Can someone explain the difference between Excel Tables and Named Ranges in Excel 2007? It seems that in addition to having the features of Named Ranges, they're somehow marked as Tables which gives ...