Stack Overflow
Stack Overflow

Questions tagged [named-ranges]

A named range is a defined area, typically in a spreadsheet or document, used for future reference. A range can be one cell in a spreadsheet, or a range of cells.

Named ranges (or defined names) in spreadsheets are used to refer to one or several contiguous cells.

Ranges will automatically shift the while the layout of the Worksheet changes (adding or deleting rows or columns). Furthermore, named ranges can be defined with formulas.

609 questions
4
votes
1 answer

Run-time error when deleting a named range

I don't understand why I keep getting a "Run-time error '1004': Application-defined or Object-defined error" message when trying to delete a named range. Here's the code used to import data from a .csv file and name the range as "history" With…
y-i_guy
  • 673
  • 6
  • 8
4
votes
2 answers

Python xlrd Named Range Value

Using XLRD in Python to read from Excel. Simple scenario. I have a cell with a value and this is associated with a named range. NamedRange "Foo" = Sheet1!$A$1 The value in A1 is "Bar" book =xlrd.open_workbook("") rng = book.name_map['foo'][0] #…
Dickster
  • 2,969
  • 3
  • 23
  • 29
4
votes
1 answer

Chart doesn't update when adding new rows to an existing Excel table (not without having to use named ranges)

I'm really new to the use of closedXMl and Excel too(at least for this purpose) so sorry if I'm asking silly questions. I know that closedXML doesn't support charts yet so the only thing that came to mind to get around this was to create my chart …
eddy
  • 4,373
  • 16
  • 60
  • 94
3
votes
2 answers

Getting the value of a Name with no range

I have a workbook, UserFileBook, that contains the Name 'Version' which simply refers to a number (it does not refer to any range, in the Name Manager it just 'Refers to =5'). I am trying to compare this number with the version number of a different…
J_Nyiri
  • 61
  • 6
3
votes
1 answer

Excel - Create chart from range of cells while excluding null values?

I've got this Excel sheet which basically contains a lot of data. Now, this Excel sheet is updated dynamically via a macro that imports the data. So the data might change, meaning, some cells might be populated, while others won't. So I've got this…
Kenny Bones
  • 5,017
  • 36
  • 111
  • 174
3
votes
1 answer

Google Sheets Named Range - reference single cell and enable pull-down

I am trying to simplify my google sheet with named ranges to not be driven nuts by the formulas I have built. I have named quite some ranges and now I am trying to replace the cell references, e.g. C22 with the named range cell name. So far I used…
thimplicity
  • 87
  • 8
3
votes
0 answers

Range selection indicator disappears from correct range after 6 worksheets in protection loop, then selects G10 by end of loop

this is my first question here. Using VBA in Excel, I'm directing the user to a specific cell that they missed filling out. But it refuses to select the correct range, instead selecting G10 each time without fail! G10 is an irrelevant, blank,…
ionizing
  • 68
  • 7
3
votes
2 answers

AutoFilter vs ShowAllData

Background: Since recently I came to know about a secret named range that gets created through using AutoFilter. Usually (if not always) this is called "_FilterDatabase". I thought about playing around with this a little, but then got stuck on the…
JvdV
  • 70,606
  • 8
  • 39
  • 70
3
votes
1 answer

Why do I get a 1004 Error when I loop through ActiveWorkbook.Names and try to delete Named Ranges using VBA?

I have a macro that needs to delete all named ranges in my Workbook. Every time I run it, I get a 1004 Run-time error unless I include an error handler. When I include an error handler, it works and actually deletes all of the named ranges. Why does…
Mona Dandan
  • 31
  • 3
3
votes
1 answer

Reference Named Ranges in VBA

In my Excel workbook, I've made a single cell a named range. Instead of using vba to do this, I just went to Formulas > Name_Manager > New in Excel. I now want to refer to this named range in a macro that I'm writing. The macro will copy the…
Dave F
  • 109
  • 2
  • 9
3
votes
2 answers

Reference Specific Row in Named Range within another Named Range

I'm writing a spreadsheet to keep track of a small business' financials. They operate a few Rooms for rent, and the structure of the document is made so that each sheet holds a year's worth of booking for all the rooms. Essentially, each row is…
Skwiggs
  • 1,348
  • 2
  • 17
  • 42
3
votes
2 answers

How to join returned values from named range separated by comma

I've spent hours trying to find out how to join returned values from a named range, but the result is a run-time error 32 - Type mismatch. As a newbie I'm still struggling with arrays, so maybe I've overlooked some detail. Thank you for helping…
W. Duri
  • 35
  • 6
3
votes
1 answer

How do i filter a range in another sheet with VBA without activating the sheet

Good day, I am having problems with Set Ranges and it has been quite frustrating when using set ranges from non-active sheets. The problem is: I have a sheet called "Dashboard". In this sheet i have a Listbox that when selected will filter values…
Raphael Yaghdjian
  • 79
  • 1
  • 8
3
votes
2 answers

Change Named range EPPlus

I'm using EPPlus to populate an excel file, I have many pivot tables that refresh when the file is opened. Their source is always one of the two sheets populated by my application. The problem is that everytime I populate there is a different…
Carlos Siestrup
  • 1,031
  • 2
  • 13
  • 33
3
votes
2 answers

Excel using INDEX to get row from named range causes formula error

I have a very simple formula to get the sum of values in a row: =SUM(K5:P5) However, K5 to P5 is the first row in a named range, and I would prefer to reference the named range, so I change it to: =SUM(INDEX(S2ScoresTotUnitQ1,Row("A1"),0)) But I…
user3925803
  • 3,115
  • 2
  • 16
  • 25
1 2
3
…
40 41