Top "Named-ranges" questions

A named range is a defined area, typically in a spreadsheet or document, used for future reference.

Get sheet name from a named range's Name object

I have: Microsoft.Office.Interop.Excel.Workbook wb; Microsoft.Office.Interop.Excel.Name name; Is there any way to get …

excel named-ranges
Excel VBA - ShowAllData method of Worksheet Class failed

I have automated a proper record input into the table that I use as a database, and when the table …

vba excel filter named-ranges
Refer to an excel named range on another sheet using indirect

Let's say I have three sheets (let's say Sheet1, Sheet2 and Sheet3). Sheet1 and Sheet2 contain each a sheet-level range …

excel dynamic named-ranges
VBA Excel: Rename columns for easy referencing

I am writing a script that transfers data from Excel cells to different word tables. So far, I am doing …

vba excel range named-ranges
In Excel 2007, how can I SUMIFS indices of multiple columns from a named range?

I am analysing library statistics relating to loans made by particular user categories. The loan data forms the named range …

excel indices named-ranges sumifs
Unable to query named range on sheet with spaces in name in Excel

I have a workbook with multiple sheets, and each sheet has the same set of named ranges (IE they are …

sql excel named-ranges vba
using conditional named range in excel

Let me try this again, I've been searching the web and can't seem to find anything. What i'm trying to …

excel excel-2010 named-ranges
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 …

excel charts worksheet-function named-ranges
AVERAGEIFS does not work, but AVERAGE(IF( does

We have a large spreadsheet that we use to calculate performance for race car drivers. It has been stable for …

excel excel-2010 average named-ranges
how to get the value of a defined name in another workbook, using vba for excel

I have several workbooks containing calculations and I am making an "automatic overview" combining the data in all those sheets. …

excel named-ranges vba