I have a list of 594 named ranges in a workbook with nearly 20 sheets, each sheet has about 200 columns of data. I need to find out where the named ranges are being used so as to remove irrelevant ...

I need two dynamic drop down lists for data validation. One containing a unique list of continents to choose from, and then the second list which is a dynamically generated subset of countries base...

I'd like to apply a conditional formatting rule to a named range. Is that even possible? How do I do that? When trying to enter the Name of the Range to the Field where you set up the range the rul...

I have a workbook with multiple sheets, and each sheet has the same set of named ranges (IE they are scoped to the sheet, not workbook). I want to query based on a named range on any of the sheets...

What I have is part descriptions that I have split into separate columns. All columns have headings, but not all columns contain information for every part, ex: some might have size, material, and ...

For example, I have a named range A10—A20 as Age; how do I get Age[5] which is same as A14. I can write "=A14" but I did like to write "=Age$5" or something similar.

I have a spreadsheet with lots of named ranges, and I'd like to have a sort of table of contents which provides hyperlinks to jump to them. In the UI I can create a hyperlink to a named range, whi...

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 ...

Currently I have such formula: COUNTIFS(B3:B36,"16",E3:E36,"01") Would it be possible to turn these ranges B3:B36 and E3:E36 into variables, like B'start_cell_value':B'stop_cell_value'. The whole...

The Google Apps Script API for Docs has a number of methods defined that work with Named Ranges in Docs. While I am familiar with Named Ranges in Sheets, I cannot find a way to name a range in Docs...

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 may...

Situation: I am getting #Value! when trying to pass the OFFSET of a dynamic named range to SUMPRODUCT. Setup: I have the following data in range A2:B4 of Sheet1. | TextA | 1 | |-------|---| | T...

I have a table in Excel with column headings that correspond to part of a dynamic named range elsewhere in my workbook. For example, I have these column headings: "10", "20", etc., and these dynami...

I have a worksheet where I have defined names for certain cells. These cells will be used in the function and I am calling them using their names. However, I get 0 as a return of the function when...

In Google Docs Spreadsheets, one can use Range Names to put labels on ranges of cells to make formulas more legible. In most formulas, one can use the range C:C to denote the entire C column, and C...

EDIT: Title changed for clarity. Quick summary: I want to know if the behavior of workbook-scoped, worksheet dependent named formulas (which I will describe below) is a documented feature in Excel...

I have an Excel question, I am wondering if there is an easy way to set up a clone or copy of a named range in one worksheet to another worksheet in the same workbook. I need this to be done automa...

To elaborate, let's say I have two named ranges in my workbook. Both named ranges have the same Name (let's say "myName"), but one is scoped to Sheet1 and the other is scoped to the Workbook. Giv...

Can the getRange be used to have a named range instead of an area? When I seem to do it, it says the argument must be a range. For example, Instead of: getRange("A4:E7"); The area of A4:E7 h...

I have: Microsoft.Office.Interop.Excel.Workbook wb; Microsoft.Office.Interop.Excel.Name name; Is there any way to get the worksheet name that the named range is on in the given workbook, assumin...

Dim sampleRange as Range Set sampleRange = Worksheet.Range(Cells(1,1),Cells(1,4) sampleRange.Name = "Range1" MsgBox sampleRange.Name The above code will show the actual address of the range, not ...