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
0
votes
1 answer

Named range in Excel/VSTO being returned even after it's been 'deleted' in Excel

I'm using VSTO (on Visual Studio 2008 due to a client request) to create Named ranges on single cells, which are then saved to the workbook and subsequently read when the application restarts. If I delete a row containing one or more named ranges…
Pete
  • 62
  • 4
-1
votes
0 answers

Is it possible to use XLOOKUP for multiple criteria (boolean method) using table columns as arrays rather than ranges?

I am using XLOOKUP to basically replace INDEX-MATCH array formula combos in my worksheet. Hoping to make the workflow faster with this. And I have been successful when using the boolean method for multiple criteria, as long as I reference the whole…
Gerardo Alonso
  • 1
  • 4
-1
votes
1 answer

TypeError: cannot read null (reading 'getRange')

I am trying to code a spreadsheet to automatically distribute payment to each person. Here is the link. I want it to distribute payment without deleting old payments. Here is the script I am using: const payDay = () => { // get spreadsheet …
Katt K
  • 1
-1
votes
1 answer

Loop through two ranges

I need help in looping the code below through my named range or just skip blank rows. Below code works fine until it stumbles upon a blank row. My textboxes for this code starts at 58 and runs trough 66. But the value from these textboxes should be…
uscmax
  • 1
-1
votes
1 answer

Invalid ReplaceNamedRangeContent request

I can successfully create a name range using batchUpdate api, however, replaceNameRangeContent gives the following error: { "error": { "code": 400, "message": "Invalid requests[0].replaceNamedRangeContent: Named range with ID kix.ydbik9q4xmna…
docmrc
  • 11
  • 1
-1
votes
2 answers

.net Excel Range Address limitation

I want to define multiple areas in one single Excel.Range object. The purpose is to colorize multiple different areas by setting one single Range. This should save time using the Excel interop, which is very slow in such operations. The problem is,…
Bastian
  • 1
  • 3
-1
votes
1 answer

Macro to ensure two cells always have the same color

I have 4 different cells, each on a different page in my Excel workbook. Each is a single-cell named region. I want these 4 cells to ALWAYS have the same matching background color. Can I use a macro to ensure that three of these cells always have…
Dave F
  • 109
  • 2
  • 9
-1
votes
1 answer

How to loop through named ranges

I have some code that imports .bas files and i need it to run though 2 named ranges. The first (MacroName) would be a list of file names (e.g exam.bas, print.bas...) and the second (ImportDate) will be the date that the file was imported. The code…
Robert Hall
  • 191
  • 3
  • 11
-1
votes
2 answers

Copy a Row and Paste only those Cells that contains Formula

I have a named range. I am inserting a new row by code and resize the named range. Some columns contains formula, some contains values. I want to copy formula from the above cells. Below is my code: Sub InsertRow() Dim lrInputRange As Long …
Avin
  • 1
  • 1
-1
votes
1 answer

How to make a function read a string as a named range on Google Sheets

Let's say I have a long list of twelve different names in one column and a value to the right column for each name. I already assigned a value to each of the twelve names by using the Named Range in Google Sheets, so I want to create a third column…
Liam Anderson
  • 1
  • 2
-1
votes
2 answers

How to use Arrayformula with named ranges?

How can I get data from named ranges together in another tab to show results from a sheet with data using a drop down menu to chose a name and get the range of the named ranges? The example sheet. As you can see, the data sheet contains all data and…
Errious
  • 53
  • 1
  • 10
-1
votes
1 answer

Excel COUNTIFS Issue

=COUNT(Due_Date
kevin
  • 13,559
  • 30
  • 79
  • 104
-1
votes
1 answer

Excel Reserved Name for Named Ranges

I am looking to create named ranges to make linked data validation. But the names that I must have seem to be reserved. I must name the ranges L5, L6, L7, etc. Is there a way around the reserved name? Here are my lists I am looking to create…
user823527
  • 3,644
  • 17
  • 66
  • 110
-1
votes
1 answer

Excel VBA - Copy from various workbooks named range to one "recap" workbook

Hi everyone and thanks in advance for your time. I am not a huge specialist in vba but sometimes it helps me to gain some good times on repetitive tasks I am working on. I would like to gathered information from various files to one "recap" file. I…
Jeff D.
  • 3
  • 1
-1
votes
1 answer

COUNTIFS incompatible with Named Range?

I have a formula: IF(AND(COUNTIFS(A:A,A1,B:B,"Bob")+COUNTIFS(A:A,A1,C:C,17)>=2,C1=17),B1,"") that does the following: If "Bob" is in Col B AND there is a "17" in Col C while still having a1 in Col A Then retrieve data from Col B on same row as…
charlie637
  • 1
1 2 3
…
40
41